August 20, 2010 at 1:33 pm
I just installed SQL Server for the first time ever, and I am really confused by the configuration. It seems that authentication is done automatically through Windows, but I need to connect to SQL Server using Perl, which requires me to provide a DSN, username, and password.
Can anybody quickly tell me:
1. How to figure out my username/password? Is it somewhere in Microsoft SQL Server Management Studio?
2. How to figure out what the server is so I can create a DSN? I am trying to create a System DSN using Windows XP "ODBC Data Source Administrator," but I'm at a loss for what to answer for "Which SQL Server do you want to connect to?" (the dropdown is blank)
Thank you so much. For some reason finding these basic answers using Google has eluded me so far.
August 20, 2010 at 1:36 pm
You need to change authentication to Mixed Mode, which lets you create SQL logins.
Then, you need to create a new SQL login for the app to use, and give it whatever permissions it needs.
If you do a quick search you should be able to find tutorials for that stuff (searched for mixed mode, and create login)
August 20, 2010 at 1:44 pm
Ok. Would that allow me to create a DSN as well? That is the main source of my problems because I'm not sure what to call the server in the Windows Administrator dialogue. It almost feels like its broken because the dropdown freezes for a minute before letting me select the server (and then it's blank).
August 20, 2010 at 2:06 pm
Don't rely on the dropdown. Type in the server name, and if applicable the instance name or port, of the server straight into that field. If the server is up and responding it will let you move to the next steps.
August 20, 2010 at 2:20 pm
Ok, I was able to create a new user. Of course, as luck would have it, now I can't log on to Microsoft SQL Server Management Studio at all :). Using the same creds as before, I am getting Error 10061 (No connection could be made because the target machine actively refused it.) Could that have been caused by going to mixed mode? I am my own administrator so I can't see why I can't get on.
August 24, 2010 at 10:19 am
In case you're curious, I was able to fix my problem in Sql Server Configuration Manager. Somehow, TCP/IP protocol got disabled...
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply