September 29, 2006 at 7:50 am
I'm deploying SQL Express 2005 with Visual Studio 2005.
For security purposes I need to change the SA password and drop the built-in Administrator group
I don't need any end users viewing or reverse-engineering my database.
So following this example:
Q. How do I login to a default installation?
VS2005 simply installs SQL Express in a default state, I think....
October 2, 2006 at 8:00 am
This was removed by the editor as SPAM
October 11, 2006 at 3:00 pm
Using OSQL, if you use the -E switch, it uses a trusted login.
We use it to add other logins to our DB like that.
February 4, 2009 at 6:56 am
I always install the SQL Server 2005 Management Studio Express. You can find a seperate & free setup of this on the Microsoft Download Center.
When starting up the management studio, you can access your servce instance by using windows authentication. For this you need to be logged in as an administrator (local or domain)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply