Results 1 to 4 of 4
Thread: MSSQL server 2000 connectivity
-
05-03-2006, 08:00 PM #1Junior Guru Wannabe
- Join Date
- Apr 2006
- Posts
- 64
MSSQL server 2000 connectivity
I am facing difficulty to connect sql server with Client utilities. When I tried to create new sql server registration it don't connect it prompting me an error " Connectio0{} not found or sql server not found " Please advise
Regards
-
05-03-2006, 09:52 PM #2Aspiring Evangelist
- Join Date
- Mar 2006
- Posts
- 427
have you register the instance in the Client Network Utilities ?
-
05-04-2006, 12:44 AM #3Web Hosting Master
- Join Date
- Mar 2006
- Posts
- 648
connect to MS SQL Enterprise Manager
Open the SQL Server Client Network Utililty (Start -> Programs -> Microsoft SQL Server -> Client Network Utility)
Click on the "Alias" tab
Click "Add" and enter the following information:
Server Alias - Servername
Network Library - TCP/IP
Computer Name - x.x.x.x(serverIP)
Port Number - by default 1433(check it)
Click OK
Click OK - This will close out the Client Network Utility
Open Enterprise Manager. Right Click "Microsoft SQL Servers" and select "New SQL Server Registration" This will open a wizard. Click Next.
Select "Servername" from the list of available servers and "Add" it. Click Next.
Choose to connect using SQL Server Authentication
Enter your assigned username and password. Keep on clicking next until the wizard is completed.
:-)
-
05-04-2006, 03:53 AM #4Junior Guru Wannabe
- Join Date
- Apr 2006
- Posts
- 64
Originally Posted by besty