December 17, 2008 at 4:17 am
Hello,
Picked up SQL Server 2005 from the Action pack for the first time as I’ve been given Primavera P6 (planning application) to install on my home PC to design a training package.
I was told I would need to install SQL Server to run Primavera, so I did just that and it all seemed fairly straight forward when I installed SQL.
On running the Primavera setup, I’m being asked for an Admin Name and Password for SQL Server 2005. I have no recollection of setting one up and haven't been able to find information in the help files.
Surely this is a simple problem, but as I said - today is my first day at trying to set SQL up, so I know literally nothing about it.
Any help would be really appreciated as I’m beginning to run out of walls to bang my head against.
thanks
David
December 17, 2008 at 5:04 am
During installation who have to decide if you use Windows only authentification or Windows and SQL. In the second case you have to enter a password for the sa account which is automatically created. I assume that you've chosen to use Windows only which is the default.
If your application can't use a windows account you have to reconfigure your SQL Server to accept SQL logins as well. To do this open the server proerties in SSMS and go to Security.
Then you have create a new SQL Server login which can be used by the application.
[font="Verdana"]Markus Bohse[/font]
December 17, 2008 at 6:03 am
really sorry, LITERALLY the first time i've ever used this, so i dont know how to do that.
Pretty sure on installation i went for Windows only authentication
Presumably by SSMS you mean SQL Server Management Studio
when i open that it asks to connect to a server, i cancel that as i don't know the login.
From there, i dont know how to go to the server properties. Don't worry if you can't respond, i'm really after a complete noddy guide, but just needed this all sorted yesterday
December 17, 2008 at 6:54 am
dcumming (12/17/2008)
Presumably by SSMS you mean SQL Server Management Studiowhen i open that it asks to connect to a server, i cancel that as i don't know the login.
From there, i dont know how to go to the server properties. Don't worry if you can't respond, i'm really after a complete noddy guide, but just needed this all sorted yesterday
Why do you cancel the login? Use windows authentification and if you are a local administrator you should be able to connect to SQL Server.
But are you sure that you're the right person to do all this. It's pretty obvious that you have no clue about SQL Server, so why are you doing this at all. Even if there's no on else with SQL Server knowledge in your company, the application vendor should have someone more knowledgeable or at least some good documentation.
[font="Verdana"]Markus Bohse[/font]
December 17, 2008 at 8:00 am
freelance trainer - I am my company but unquestioniably the wrong person to do it! Alternative is obv. to pay someone hundreds of £ to do it, which i'd rather not.
As it happens, Express version will do the job and i've got that (almost) to work.
i just wish that software companies would make software a little easier just to get on to the bleedin' machines. But gues why do that if they can turnover £m's in support revenue!
thanks anyway
December 17, 2008 at 8:05 am
Hi there, just reading you plight and the solution is really quite simple.
1. Open up SSMS (SQL Server Management Studio).
2. When it opens up you will have something like the attached (untitled), assuming you havent installed a 'named instance' just enter your machine name and click connect. In the attached you can see I use a named instance so the format is {machine name}\{named instance}.
3. That should have got you in. Right click on the server (left window) and select 'Properties'.
4. In the properties dialogue (attached as untitled2) go to the 'Security' tab (shown in attachement), change the 'server authentication' mode from 'Windows Authentication mode', to ' SQL Server and Windows Authentication mode'.
5. Not sure what will happen next as never done this (Windows only auuthentication not preferred method), but either straight away or when you click 'OK', you will be prompted to enter an 'SA' password. This is for the SQL Sysadmin account (GOD user). It is this account you should use with your program.
Obviously I have scipt a lot of the SQL blah about best practices and security but as you are doing this at home on a local machine to write a guide, I hardly think it matters.
See how you go and get back to me if any questions. And dont worry about the eaarlier cold reception, we're not all grouchy and condescending (i cant even spelll it).
Hope this hasnt put you off. 🙂
Adam Zacks-------------------------------------------Be Nice, Or Leave
December 17, 2008 at 8:14 am
i didn't find the answer condescending, indeed as i pointed out in my next post he was absolutely right.
😀
However, i think I've found a solution with the Express version.
Having now tried to use two of the full versions i got with the MS Action Pack (Server 2008 and SQLS 05), from now on i'll stick to the noddy versions (SBS and Express) until i get the hang of it or find that my usage necessitates upgrading to the 'full' version. Just tried the full versions as they were sat there smiling at me!
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply