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?
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.