Need help pointing to database.

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Need help pointing to database.

Author

Topic

Kudelaw
Starting Member

3 Posts

Posted - 2009-08-22 : 15:27:38

I just installed SQL Server on my computer (sql2ksp3.exe). Just the basic server with the "Service Manager" No tools...no nothing. It's up and running and points to the "default database" (c:\Program Files...\master.mdf)

I've installed my software and when I run it...it says (Login failed for user 'xxxxx'). I think I understand why this is happening. I believe it's because the "default database" does not have this user registered. And looking inside the the software's database - this user is registered.

So my question is how do I get my sql server to point to the software's database on start up?

Please don't tell me to open a tool that came with SQL SERVER 2008. I don't have that. I will have to do it via the DOS command prompt...Just give me the command line. Thanks in advance.

-Kudelaw

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-08-22 : 16:14:21

Open dosprompt on machine that runs sql server

C:>sqlcmd -S<yourServerName> -U<yourUser> -P<yourPwd> -dmaster
1>alter login <yourUser> with default_database=<yourWantedDB>
2>go
1>exit

No, you're never too old to Yak'n'Roll if you're too young to die.

Kudelaw
Starting Member

3 Posts

Posted - 2009-08-22 : 16:26:01

Thanks for the information webfred. Let me try that. I'll keep you posted. Please check back.

Kudelaw
Starting Member

3 Posts

Posted - 2009-08-22 : 16:33:36

It says "sqlcmd" is not recognized as an internal or external command operable program or batch file.

I'm at the cmd prompt c:\>

Not sure where to navigate to.

I'm on the computer where the server is hosted

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2009-08-23 : 07:41:28

It's in C:\Program Files\Microsoft SQL Server\100\Tools\Binn
or whichever drive you're installed the software.
Also check your PATH variable. And add it, if required.

Else search for SQLCMD.EXE

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources