August 12, 2005 at 8:06 am
Maybe someone can help me. I installed MSDE rel A on my XP desktop from a command line with the following parameters:
setup SAPWD="password" INSTANCENAME="janice" SECURITYMODE="sql"
The install seems to work fine. when it's complete, I go into Services and start the newly created MSSQL$JANICE service.
Once I do that, I go to Enterprise Manager and register the new Server but It does not show up in the Server list. When I try and ADD it and then connect to it - it won't allow me to connect.
Any idea what I might be doing wrong????
August 12, 2005 at 9:02 am
How are you trying to connect Enterprise Manager? Are you using the SA account?
What errors are you getting (look in the Windows Event Viewer logs)?
Can you connect using Query Analyzer?
-SQLBill
August 12, 2005 at 1:57 pm
I tried the 'sa' account and I also tried using windows authentication. no error - just won't connect saying the server does not exist and the registration fails.
I also just tried connecting to the instance via query analyzer - won't connect.
also, the new server does not show up in my SQL Server Service Manager list.
The only entries in the Event logs are when I started and stopped the SQL Server Service. Not sure what I'm doing wrong!!!!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply