connection to sql server

[curiousvbnet]

Hi,

By error, i have suppressed the connection to sql serveur( version 8)
Whan i want ot register the sql server with the assistant help, i receive a message the server i have selected does not exist or its access is refused.

I don't know what to do to register my sql server.

The message ireceive is this one
an error of type 1060( the service does not exist as an installed service)happened during the execution of this service operation on the ms sql server service

When i go the the configuration display+administration tools+services , i can not see the MSSQLSERVER service , as it has to be.

I have removed the microsoft desktop engine and this problem happened just after; i think it is link to this suppression.

To try to register , i have worked from the service manager

Could you help me to solve this big problem because i can not work at all if it remains.

Best regards.
Nathalie

 

[ptheriault]

I have removed the microsoft desktop engine and this problem happened just after; i think it is link to this suppression.

Umm, sounds to me like you uninstalled your server and that is why you are getting that error!

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[curiousvbnet]

Ok,

So now, what do i need to do exactly to make it work?

Thanks a lot for your help.

Nathalie

 

[gmmastros]

install MSDE.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[curiousvbnet]

Hi,

Excuse me but it seems you did not understand what i told.

i have removed MSDE and it caused problem with MS SQL server.
I don't need MSDE at all, i only need MSSQL server !

Thanks a lot again for your help.
Nathalie

 

[ptheriault]

If you open the services program on the server is the SQL Server services running? Is the instance of SQL you are trying to connect to local or remote? Do you have the correct name of the SQL instance? Is it a named or default SQL instance?

- Paul

- If at first you don't succeed, find out if the loser gets anything.

 

[gmmastros]

I am perfectly willing to admit that I did not understand your question, so... let me explain what I do know.

When you install MSDE or SQL Server 2000, it will install a default instance (unless you tell it otherwise). This default instance will appear in the services list as MSSQLSERVER. By looking at the services list, you cannot distiguish which version of the database engine is installed.

You can install SQL Server (or MSDE) multiple times on the same computer. Only 1 of those installs can be the default instance. Each one, thereafter, will become a named instance. When you look in services, the named instances will appear as MSSQLSERVER$WhateverNameYouGiveIt.

If, as I suspect, you originally had MSDE on this computer, and then later installed SQL Server, then it would have installed as a named instance (if you left MSDE installed while installing SQL Server).

In Enterprise Manager, you can see (and easily tell) which servers are installed as the default instance and which are installed as a named instance. The default instance will appear in the list of servers as the computer name. Named instances will appear as ComputerName\InstanceName.

My suggestion to you is.... first, determine if there is a default instance or a named instance installed on the computer. Then, change the connection string to include the named instance (if there is a named instance installed).

Hope this helps.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[curiousvbnet]

Ok George,

Thanks a lot for all these interesting explanation.

i have well understood and will test all what you adviced me to and will come back to you to tell you what happens exactly.

Best regards.

Nathalie