SQL Server Logon

[bankajac]

I am using SQL Server 2005 x64 running on server 2003. I have an application which I purchased that requires an SQL database. There is an app that the instructions tell you to run to create the database. The app asks for SQL Server Name, SQL DB Name, SQL Server System Admin Logon, SQL Server System Admin Password, SQL Server Practice Management Logon, SQL Server Practice Management Password.

When I enter everything in I get an error saying that it is "unable to open master database with this SQL Server System Admin user id and password. Please verify you have eneterd the correct user id and password for the SQL Server System Admin.

If SQL Server uses windows authentication then my username would be DOMAIN\Administrator and the password would be the windows administrator password. Is that correct? What am I dooing wrong. I know very little SQL Server.

Thank you.

[POWER2112]

I am using SQL Server 2005 x64 running on server 2003. I have an application which I purchased that requires an SQL database. There is an app that the instructions tell you to run to create the database. The app asks for SQL Server Name, SQL DB Name, SQL Server System Admin Logon, SQL Server System Admin Password, SQL Server Practice Management Logon, SQL Server Practice Management Password.

When I enter everything in I get an error saying that it is "unable to open master database with this SQL Server System Admin user id and password. Please verify you have eneterd the correct user id and password for the SQL Server System Admin.

If SQL Server uses windows authentication then my username would be DOMAIN\Administrator and the password would be the windows administrator password. Is that correct? What am I dooing wrong. I know very little SQL Server.

Thank you.

Check to make sure your domain login has adminstrative rights on the server SQL is running on. If that doesn't fix your issue, check that 3rd party's SQL Server requirements. I've seen some 3rd party software which requires you to actually use the "SA" login, and not just a domain login.

[bankajac]

I tried the sa account and no luck. As far as checking to make sure that my domain has administrative rights on the server SQL is sunning, how do I do this. I am able to log on to SQL Server Management Studio with windows authentication.

[bankajac]

I fixed it. I enabled to sa account but noticed that I still could not use it to log into SQL Server. I then enabled Windows and SQL Authentication on the server and tada, it worked!!! I had to use SQL Authentication with this app as it did not support Windows Authentication.

[POWER2112]

I fixed it. I enabled to sa account but noticed that I still could not use it to log into SQL Server. I then enabled Windows and SQL Authentication on the server and tada, it worked!!! I had to use SQL Authentication with this app as it did not support Windows Authentication.

Kudos - yeah, some of those 3rd party apps can be tricky. They hand you a box saying "Here, all you have to do is run this.", when it just don't work that way in real life. :)

[bankajac]

Welcome to Neowin by the way! I appreciate all your help. This is a great community!

[bankajac]

I thought that all was well and now the application tells me that that database is not available. This was after it created it. Any suggestions on how to troubleshoot this?