Thursday, May 03, 2012 9:33 AM
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
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
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?
Thursday, May 03, 2012 9:45 AM
Thursday, May 03, 2012 9:50 AM
Thanks for your reply.
I just checked and it is using a backslash, i typed it incorrecly
But still no connection.
Friday, May 04, 2012 5:14 AM
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.
Friday, May 04, 2012 5:30 AM
Thanks, but yes i have definitly used the correct instance name. I checked it!