i've read every thread i've found online related to this issue(and followed the steps they showed) and i cant' still access the database; it keeps throwing the "refused remote connection" error, It is kind of weird because i can browse through the database on the "server explorer" tab on Visual Studio (and that is remote accesing also, shouldn't that fail too?) do you have any ideas? thanks.
Asked
Active
Viewed 482 times
0
-
– Marcox May 22 '13 at 15:22 -
Are you sure SQL Server is a default instance and not a named instance? – Aaron Bertrand May 22 '13 at 15:25
-
Nope. How can i do that? – Marcox May 22 '13 at 15:34
-
You need to check in SQL Server Configuration Manager if the instance is named `MSSQLSERVER` or something else like `SQLEXPRESS`. If it is not `MSSQLSERVER` then your connection string needs to say `localhost\instancename`. – Aaron Bertrand May 22 '13 at 15:38
-
Sorry, I can't find a field for the instance nam on SQLSCM, could you please guide me through it? Thanks for the help by the way. – Marcox May 22 '13 at 16:41
-
http://i.stack.imgur.com/XiFES.png – Aaron Bertrand May 22 '13 at 16:45