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.
| Author |
Topic |
|
pascal_jimi
Posting Yak Master
167 Posts |
 Posted - 2013-07-03 : 03:19:17
|
| hiI installed sql server 2005version 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 Computerkmkmmm |
|
|
pascal_jimi
Posting Yak Master
167 Posts |
Posted - 2013-07-03 : 03:41:49
|
| CREATE LOGIN shcooper WITH PASSWORD = 'Baz1nga'but i does not connect to sql server with sql authenticationkmkmmm |
 |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2013-07-03 : 06:12:14
|
| are both the systems on same network??and during installation what type of authentication did you specify?mohammad.javeed.ahmed@gmail.com |
|
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-07-03 : 08:51:03
|
| 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 |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2013-07-03 : 13:07:13
|
| 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. |
|
|
|
|
|
|
SQL authentication