SQL Server 2008...Cannot access remotely?

Question

Hi, i have configured MSSQL 2008 and have setup a named instance SPSQL.

I am trying to allow remote connections to this instance. My server name is SERVER

SERVER/SPSQL

However, the program and client will not connect to this SQL Server. I can sucessfully logon to the instance with windows authentication on the SERVER (localhost)

I have followed this guide

http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx

specified a port in configuration manager, opened it in firewall, and also added sqlservr.exe for my instance as a program. None of these have worked!

Has anyone any ideas?

Thanks!

Answer 1

SERVER/SPSQL

Hello,

You have to use a backslash, not a slash for the instance name =>

SERVER\SPSQL

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 2

Thanks for your reply.

I just checked and it is using a backslash, i typed it incorrecly

But still no connection.

Thanks!

Answer 3

Have you use the correct server and instance name?

You can look up the instance name in Service Manager (services.msc), there you will find an entry like "SQL Server (SPSQL)"; the instance name is placed in brackets.

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 4

Thanks, but yes i have definitly used the correct instance name. I checked it!

Thanks