MSSQLSERVER 2005 LOGON PROBLEM TO MANAGEMENT STUDIO

I am trying to get the databases detached from windows server 2003 sql 2005 sp3 to move to attach to another virtual machine with server 2008 x64 sql server 2008.  I can't logon to SQL Management Studio on localhost to detach the database.  Can I get the databases out to restore without opening sql 2005?  If not need help to open sql 2005.
1.  My IT retired and I am a newbie.  Can't remember how he logged in or what changes may have happened:  Server name: nameserver\mssqlyserver?  Was setup as windows authentication
2. response to sqlcmd.exe:
HResult 0x2, Level 16, State 1
Named Pipes Provider: could not open a connection to SQL server [2}
Named Pipes error -40
3. System event log says:  7041:  msftesql service was unable to longon as domain\Administrator:  user hasn't been granted the requested logon type at this computer
4. Application log says: Event ID 1053; User: NT AUTHORITY\SYSTEM; Windows can't determine the user or computer name
5. No firewall on the 2003 virtual machine
Thanks, Luke



 
LCalabreseAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

HyperBPPCommented:
Is there a SQL Browser service running?
0
LCalabreseAuthor Commented:
Hi
pinging the virtual machine works.  telnet to 1433 does not.  
Nothing on sql 2005 runs due to logon failure. There is no isp:  servers are in house.
Links above:  not able to troubleshoot from this information
Is there anything required on the DC apart from the Computer being added and the dns ip address being correct?
Thanks, Luke


0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

HyperBPPCommented:
Are named pipes enables?  Is the TCP protocol enabled, and set to the static port of 1433?

http://support.microsoft.com/kb/823938
0
LCalabreseAuthor Commented:
1. When I go to registry: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MicrosoftSQLserver\mssql.1\mssqlserver\SuperSocketNetLib there is no tcp listed
2.  Named pipes is definitely a major problem but can't open SQL to change and not sure how to enable with SQL locked up like this
Thanks Luke
0
HyperBPPCommented:
Your TCP protocol is disabled, and I bet the named pipes is also disabled.  You can fix both of these through the SQL Server Configuration manager.  Do you know how to use SQL Configuration manager?  It should be on your start menu:

Start -> Programs -> Microsoft SQL Server XXXX -> Configuration Tools -> SQL Server Configuration Manager
0
LCalabreseAuthor Commented:
Enabled pipes.  
TCP/IP> TCPDynamicPort value data 1434
For 2005 is the name of the server:  computername\mssqlserver?
Any changes I make aren't in effect without stopping and starting the database engine, which I can't start.
current ERROR:  Verify the instance name is correct and that SQL Server is configured to allow remote connections, SQL Network Interface error 25; Connection string is not valid MS SQL server error 87
Thanks
Luke
0
LCalabreseAuthor Commented:
I was sent this to check User Right Assignments and sql is not listed as described in:
http://msdn.microsoft.com/en-us/library/bb283417(SQL.90).aspx  Trying to figure this out and if it is the bottom cause of this problem.
Luke
0
HyperBPPCommented:
0
LCalabreseAuthor Commented:
No matter what SQL changes I make none are effective until I can open and close the database, which is the basic problem.  Since SQL worked FINE, before we had to set up a new doman controller and I did not have SQL permissions etc in the new DC, that I need to move this question over to another forum on  Server permissions.  How do I close this thread? Luke
0
HyperBPPCommented:
Although slow, rebooting will restart SQL server if you do not have permission to use services.msc.  Good luck!
0
LCalabreseAuthor Commented:
Verify instance name is correct and that SQL server is configured to allow remote connections; SQL Network Interfaces error 25; connection string is not valid; Microsoft SQL Server error 87
0
LCalabreseAuthor Commented:
Not sure what you mean by rebooting.  Have rebooted the server and no matter what we do we get:  
Verify instance name is correct and that SQL server is configured to allow remote connections; SQL Network Interfaces error 25; connection string is not valid; Microsoft SQL Server error 87

Thanks
Luke
0
LCalabreseAuthor Commented:
Able to get in using localhost as name server.

Thanks to all of you for trying to help
Luke
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.