Friday, February 12, 2010

Programmer - The All famous SA login in SQLSERVER : Can it be enabled differently ?

Hey Guys :D



For my final year project, i'm making what i call - SeeQuaL and its a one stop interface for accessing 3 of the most famous database types - SQLite, MSSQL server and MySql. I'm Pretty sure that i can get things done with the SQLite and MySql. But MSSQL server, meh! will surely give me problems.



Now lets take the case that i have SQL Server express 2005 installed on my system but i dont have Management studio installed. Naturally in order to access databases , i will need to log in with the SQL server authentication mode AKA via the all famous login - SA.




So here is my Question:




How do i enable this account (sa) and set the server authentication to "SQL server and windows authentication" mode using management studio??





I have no idea as to how to accomplish this :( So please help me guys ! Is there some table that i need to access thro the windows authentication mode by which i can get this job done ?



Please help ! My Project depends on this :(

No comments:

Post a Comment

LinkWithin

Related Posts with Thumbnails