Link to home
Create AccountLog in
Microsoft SQL Server

Microsoft SQL Server

--

Questions

--

Followers

Top Experts

Avatar of matchbx27
matchbx27

MSDE connectivity issues (Specified SQL Server not found) / (SQL Server does not exist or access denied)
I am having some connectivity issues with a new install of MSDE Service Release A.  The Server has all updates from Microsoft as well as MDAC 2.8.

First I installed a named Instance of MSDE (Instance1).  After installing and rebooting the server I attempted to register the instance using Enterprise Manager on my development workstation.  I received the error message "SQL Server does not exist or access denied".  

Also after rebooting the Server I did not have a green arrow inside the White circle of the Server Manager app running in the sys tray.  If I opened Server Manager the named instance did not appear in the drop-down box.  If I manually typed in the \\servername\instancename, Server Manager would update and display that the instance was up and running.  However after a reboot it would revert back to showing no service running.

After several attempts to comminucate with the named instance of SQL Server on the Server, I installed a default instance of SQL Server.

Now when the server is rebooted Server Manager does display the default instance running, but still does not show the named instance in the drop-down box (I have to type it in manually).

I still can not register either the named or default instance on my workstation using Enterprise Manager.  I also tried to create an ODBC connection to both the default and named instance to no avail.

However ODBC connections on the Server will commincuate with both instances (named and default).

I have seen several posts on the web refering to Server Utilities and Client Utilities but with very little information on how to use these tools.  If these tools are needed to resolve the issue please include information (or link to information) on how to use them.

thanks,
matchbx.

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.


Avatar of adwisemanadwiseman

the problem might be stemmin from the port that this named instance is running on.  The standard SQL server port is researved for the "localhost" instance, or the instance that shares it's name with the machine name.  When other instances are added, they must utalize alternative ports and the connecting machine must know to look for these ports.  Let me dig for a sec...

Check the SQL server Client Network Utility to see if it is configured corerctly on your development machine.

It should be found in the SQL server folder in the start menue

Reward 1Reward 2Reward 3Reward 4Reward 5Reward 6

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.


Avatar of matchbx27matchbx27

ASKER

The Client Network Utility on the General Tab:

2 enabled protocols  TCP/IP and Named Pipes

on the Alias Tab 2 server alias are listed (The default instance and the named instance).

UPDATE:

SQL Server Service Manager on my workstation show both the named and the default instance in the drop-down box and both are currently running.

PROBLEM SOLVED:

adwiseman you were close....  I had to enable protocols on the Server not my development machine.  As it turned out the Network Admin's who set the Server up did not make sure it was logging into the domain.  Instead I was logging in to the local machine.  I am assuming that since I installed MSDE being logged in this way no protocols were enable by default.  Once I enabled the protocols and logged into the domain everything worked....


P.S  To enable protocols on a MSDE installation navigate to "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe"

Free T-shirt

Get a FREE t-shirt when you ask your first question.

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.


ASKER CERTIFIED SOLUTION
Avatar of modulomodulo

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Create Account
Microsoft SQL Server

Microsoft SQL Server

--

Questions

--

Followers

Top Experts

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.