CODEWITHSUNDEEP
sqlsql-server-2005
YodasMyDad
YodasMyDad

Reputation: 9475

SQL Error Locating Server/Instance Specified

Having a problem moving a site from Win2003 IIS6 w/ SQL2005 Express to a Win2008 IIS7 w/Fill SQL 2005? I keep getting this error

Desc : SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].

Can anyone point me in the right direction

Upvotes: 3

Views: 28130

Answers (2)

Machine88
Machine88

Reputation: 1

You can look at the "SQL Server Configuration Manger" and then check the SQL Server Services, pick the SQL Server option on right hand side (e.g SQL server (SQL2019)). Right click on it for properties dialogue box, then services. Check the "Host Name". This will be the instance name followed by the sql server name: John-Laptop\SQL2019.

Upvotes: 0

Sky Sanders
Sky Sanders

Reputation: 37074

If you do not have physical/remote access to log into the machine, the first thing to try is simply the name or address of the machine. It is likely that the full sql server is installed as the default instance, which is the name of the host.

If this does not work and you do have access to the machine you can open any of the configuration tools, or admin tools>computer management>services>sql services

or you can drill into the registry

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL

Or, you could just ask the administrator. ;-)

Upvotes: 1

Related Questions