Click here to Skip to main content
15,896,429 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Hello,

I have installed Studio-2005 but unable to login through windows authentication.. I tried all servernames but it doesn't work.. please help me..
Posted
Comments
ZurdoDev 28-May-15 8:01am    
How can we help? You don't know how to login to your sql server. What makes you think we'll know how to?
amaansworld 29-May-15 5:42am    
Hey mate, Don't be upset. It seems you don't understand my question..
ZurdoDev 29-May-15 7:50am    
I'm not upset. I just don't see how anyone can tell you how to login to your server.

Thanks for clearing things up.
amaansworld 31-Jul-15 0:46am    
You no need if you don't know..
ZurdoDev 31-Jul-15 7:04am    
No one knows where your servers are. Not sure why you can't understand that.

1 solution

Visual Studio 2005 does not install SQL server for you - many people would never need it.
Instead, you need to go to the Microsoft site and download SQL server as a separate application, and install it on at least one computer in your LAN segment. This can be your development machine for testing, or a production server for release - you should never try to develop against a production server, that's a route to a world of pain!

There is a free version of SQL Server you can install: Sql Server Express - you will have to decide which version you want yourself, download it, and install (Google can find it for you) - but do follow one of many the online installation guides - you have to be careful sometimes or it can conflict with all sorts of things!
 
Share this answer
 
Comments
amaansworld 29-May-15 5:44am    
Hello OriginalGriff,

While installation it didn't ask servername and other credentials.. As you know it ask servername while opening management studio. I don't know what value I should enter. Do you have any idea?
OriginalGriff 29-May-15 5:51am    
Open management studio (SSMS for short)
In the "connection" dialog that it starts with, select "Server type" to "Database Engine" and click the dropdown for the list beside "Server name".
Pick "Browse for more" or select you local PC if it shows it.
Try with "Windows Authentication" - that's normally fine for a development system
If that doesn't work, use "SQL Server Authentication" and try "sa" with a blank password (and change it when you get logged in!)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900