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
 General SQL Server Forums
 New to SQL Server Programming
 Logging on problem on standalone

Author  Topic 

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2007-08-12 : 17:32:12
I have installed SQL Server 2005 on my laptop that has Vista OS.
I want to log on only to teach myself. Is there a way that i could use the program without having to set it up on a server.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-12 : 18:32:15
You can use any sql client tools to connect to it.
Go to Top of Page

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2007-08-13 : 05:58:01
How do i setup the password to connect to it, using either mixed or windows authentication.

Thank you very much for your reply

Regards

Rob
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-13 : 15:29:06
You setup password for standard sql login in sql server. Don't need password for trusted login, windows will handle it.
Go to Top of Page

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2007-08-14 : 07:55:12
where abouts do i set the password on sql server
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-14 : 21:52:03
In ssms, check books online for details.
Go to Top of Page

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2007-08-15 : 10:38:15
please help, i am new to all this. Could you just point me in the right direction please

Regards

Rob
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-15 : 22:08:26
Did you search books online? That's the right thing you should do. Anyway, right click the account in ssms and choose properties. You can reset password there.
Go to Top of Page

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2007-08-16 : 07:15:09
what do you mean by SSMS is it Sql Server Management Services

Thank you very much
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-16 : 22:07:53
Sql Server Management Studio.
Go to Top of Page

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2007-08-17 : 04:04:07
I have installed the express edition, everytthing is fine apart from
an error report about Internet Information Services saying the settings are not correct. I am running on a new laptop with vista premium. How do i setup the iis to work with Sql server.

Thank thanks

Rob
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-17 : 23:11:11
What kind of setting? Do you use reporting service?
Go to Top of Page

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2007-08-20 : 03:35:46
It was just when i was installing express on, error message was asking me to install iis or change the settings, i imagine it was for reporting services. I am so new to all this i really am starting from the bottom. So i will probably have some silly questions to ask.

Thank you for your help

Regards

Rob
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-20 : 21:46:28
You can ignore that if you don't need RS.
Go to Top of Page
   

- Advertisement -