SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 SQL authentication
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

pascal_jimi
Posting Yak Master

Azerbaijan
150 Posts

Posted - 07/03/2013 :  03:19:17  Show Profile  Visit pascal_jimi's Homepage  Reply with Quote
hi


I installed sql server 2005


version
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 3)

1. In the "Remote Connections" option button "Local and remote connections" and "Use only TCP / IPĀ»:

2.
set FireWall, then it must allow incoming connections on TCP / IP protocol on port 1433 (for connecting to SQL Server from other computers), as well as the UDP protocol on port 1434



but does not connect through another Computer

kmkmmm

pascal_jimi
Posting Yak Master

Azerbaijan
150 Posts

Posted - 07/03/2013 :  03:41:49  Show Profile  Visit pascal_jimi's Homepage  Reply with Quote
CREATE LOGIN shcooper
WITH PASSWORD = 'Baz1nga'



but i does not connect to sql server with sql authentication

kmkmmm
Go to Top of Page

ahmeds08
Aged Yak Warrior

India
656 Posts

Posted - 07/03/2013 :  06:12:14  Show Profile  Send ahmeds08 a Yahoo! Message  Reply with Quote
are both the systems on same network??
and during installation what type of authentication did you specify?

mohammad.javeed.ahmed@gmail.com
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3712 Posts

Posted - 07/03/2013 :  08:51:03  Show Profile  Reply with Quote
This could be due to a number of reasons - see this article in SQL Server Protocols blog for a step by step trouble-shooting guide: http://blogs.msdn.com/b/sql_protocols/archive/2006/09/30/sql-server-2005-remote-connectivity-issue-troubleshooting.aspx
Go to Top of Page

jeffw8713
Aged Yak Warrior

USA
798 Posts

Posted - 07/03/2013 :  13:07:13  Show Profile  Reply with Quote
By default - SQL Server Express installs as Windows Authentication only. If you did not change that setting when you installed - you will not be able to login using SQL Authentication.

You really should be looking at using 2008 R2 or 2012 instead of 2005.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000