difficult connection to sql server

[231166]

Hi,

I have modified my login and password to access to windows 2000 and now, when i want to connect to sql server i receive this message

"the opening of a session has failed and prevents from the start of the service"
Could you help me to make sql server work because i need it absolutely.

Thanks a lot.


Regards
Nathalie Harbonne

 

[Catadmin]

It sounds like you're trying to connect to a local server on your machine. Am I correct? If not, let me know.

If so, find Administrative Tools on your box. It could be in several places on your Start menu, but either it's usually stand alone or under Control Panel, depending on the OS.

Under Admin Tools, look for Services. Open up Services and find Microsoft SQL Server and SQL Server Agent. If they are using the account in question, you need to change the passwords there (double-click the service) in order to get them to work.

BTW, this thread properly belongs on the Microsoft SQL Server: Administration and Setup forum (forum962). You should post there in the future for better answers to problems like this.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[231166]

Hi anfd thanks alot for your help.

the pb is that i don't see administrative tools on my box( what is my box?)
I can see a box with a combobox(in the tools bar on my desktop) where there are written in a combobox 'sql server', 'sql server agent' and 'distributive transaction coordinator'and the label 'services' but i can not double click on 'SQL SERVER'or 'SQL SERVER AGENT ' because they are in a combobox.
Perhaps i need to go to another place to double clik on them.

Could you help me on this point.

Thanks alot for your help.

Regards.

Nathalie

 

[gmmastros]

Another way of saying what Catadmin was saying...


Click Start->Run
Type: Services.msc
Click OK
scroll to MSSQLSERVER
Right click -> Properties
Click Log on tab.

Check the login that is used to start sql server. You may need to change the account and password.

-George

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

 

[231166]

Thanks it works very well.
Now i have a pb with my application : the connection can be opened only with one form and not with the others.
Do you think the problem is linked to the last changes?

Thanks a lot

Regards.

Nathalie

 

[Catadmin]

No. The problem is not with the services. The problem is in your application code. The form in question probably called a local connection to SQL Server rather than a global (to the application) connection. This is actually the proper way to do it, but you'll have to add connections into each one of the forms for all the other forms to work.

And don't forget to close your connections when you're done with them.

For more information on application connections, you'll want to see the Visual Basic (VB .Net) forum (if your code is in Visual Basic) or check to see if there is a C# forum. They can tell you how to properly connection pool from your application and how to do Best Practices on connection objects.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[Catadmin]

Oh, almost forgot to answer the other questions.

"Box" is synonomous with Server / PC in tech-talk.

Administrative Tools is part of the Windows OS (operating system) and is found in different locations depending on what OS you are running (XP Pro/Home, 2000 Server, 2003 Server). Usually, if you go to Start and navigate around, you can find it in the Control Panel (sometimes itself hidden under Settings) or find it listed by itself.

Hope that helps.




Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[231166]

Hi,

All is ok now : the pb with sql server and the one with the connections.
thanks a lot for all your explanation.

I have noticed them to remember when i will need them.

Best regards.

Nathalie