Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Remote SQL Server 2005 express

Status
Not open for further replies.
byRamiX

byRamiX

Programmer
Nov 28, 2006
13
IL
i'm tring to create a vb application which should connect a sql server 2005 express.
the problem is that the application will not run on the computer that has the data base, the two computers (client and server) are connect by LAN.
i configured the sql server to accept remote connections, enabled the TCP/IP Connections.
what more i should check so i can do that ?
should i install something on the client computer ?

- sportcars
- Free Banners System
- Programmig issues
- free web directory
 
Sort by date Sort by votes
Can you telnet from the remote computer to the port that SQL Server is listening on?

Check the FAQs on forum962. I've got an FAQ over there on troubleshooting connections to SQL Server.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)
[noevil]
 
Upvote 0 Downvote
If SQL is configured to listen and you still can't telnet to the port then there is a firewall somewhere blocking the port.

Have you restarted the SQL Service after telling it to listen for a connection?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)
[noevil]
 
Upvote 0 Downvote
Can you post your SQL ERRORLOG file. Everything from the first line until the line that says "Recovery complete" please.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)
[noevil]
 
Upvote 0 Downvote
i don't know why, but i can't access the sql server logs.
but i looked into the system logs and i found something that may be a clue!
it's a warning that says: The configuration of the AdminConnection\TCP protocol in the SQL instance SQLEXPRESS is not valid.
any ideas?

- sportcars
- Free Banners System
- Programmig issues
- free web directory
 
Upvote 0 Downvote
Check the SQL Server Configuration Manager.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)
[noevil]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
509
Volvere
V
gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
526
pjw001
pjw001
elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
317
Mike Lewis
Mike Lewis
grnzbra
  • Locked
  • Question
T-SQL Dialog Box
Replies
8
Views
288
Chris Miller
Chris Miller
Andrzejek
  • Locked
  • Question
Eliminate pesky [ ] in SQL Management Studio
Replies
5
Views
368
SaltyTheFrog
SaltyTheFrog

Part and Inventory Search

Sponsor

Back
Top