<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Administering
»
Issue connecting to an instance of SQL...
29 posts, Page 1 of 3
1
2
3
»
»»
Issue connecting to an instance of SQL Express 2005 over peer-to-peer network
Rate Topic
Display Mode
Topic Options
Author
Message
k_amalpasha
k_amalpasha
Posted Monday, November 16, 2009 8:10 PM
Grasshopper
Group: General Forum Members
Last Login: Sunday, November 22, 2009 10:39 PM
Points: 13,
Visits: 29
Hi,
I have an instance of SQL Express Server 2005 running on a peer-to-peer network.The server name is KAMAL\SQLEXPRESS when I run sqlcmd -SKAMAL\SQLEXPRESS on the local machine it's installed on i get 1> which is what I should be getting. but when I go to a different PC on the workgroup I am unable to connect to the server, and sqlcmd doesn't give me 1>. I am totally confused about why this is happening.
Here are some of the Settings:
1.Sql Server Configuration Manager->SQL Server 2005 Network Configuration->Protocols for SQL Express
a.Shared Memory - Enabled
b.Named Pipes - Enabled
c. TCP\IP - Enables
d.VIA - Disables
2. SQL Server 2005 surface area configuration ->Database Engine -> Remote Connections
a. Local and Remote Connections (Selected)
i. Using both TCP\IP and Named Pipes (selected)
Your Help would be greatly appreciated
Post #819771
Bru Medishetty
Bru Medishetty
Posted Monday, November 16, 2009 9:09 PM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 9:03 AM
Points: 1,427,
Visits: 1,506
You should be able to connect from another PC in the workgroup by using your system IP Address and the TCP Port of the SQL Server.
So something like this -- 192.168.1.101,1433 should be working or the PCName\SQLInstance Name should be working If you have named instance, if you have installed a default instance, then only the PC Name should be ok.
For connecting any of this way, you need to have 2 things, a SQL Server Login on the SQL Instance and also the Instance has to be using the Mixed Authentication Mode (SQL and Windows).
Bru Medishetty
To get quick answers read the article
How to post data/code on a forum to get the best help
My Blog -
learnsqlwithbru.com
Post #819787
Elliott W
Elliott W
Posted Monday, November 16, 2009 9:40 PM
SSCrazy
Group: General Forum Members
Last Login: Today @ 3:16 PM
Points: 2,406,
Visits: 1,869
Windows Firewall?
CEWII
--------------------------------
Having trouble figuring out what jobs are running in SQL Server at the same time.
Try
Sql Job History Visualization
It lets you view your SQL Job history on an Outlook style calendar..
Post #819796
k_amalpasha
k_amalpasha
Posted Monday, November 16, 2009 10:08 PM
Grasshopper
Group: General Forum Members
Last Login: Sunday, November 22, 2009 10:39 PM
Points: 13,
Visits: 29
Hi,
I have tried to log in using KAMAL/SqlExpress, which does work on my local machine, but not on the other machine, I have also tried disabling the firewall, but have not been able to connect.
Post #819803
Bru Medishetty
Bru Medishetty
Posted Monday, November 16, 2009 10:14 PM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 9:03 AM
Points: 1,427,
Visits: 1,506
Did you use SQL Login? and check the Authentication mode.
Bru Medishetty
To get quick answers read the article
How to post data/code on a forum to get the best help
My Blog -
learnsqlwithbru.com
Post #819805
k_amalpasha
k_amalpasha
Posted Monday, November 16, 2009 10:18 PM
Grasshopper
Group: General Forum Members
Last Login: Sunday, November 22, 2009 10:39 PM
Points: 13,
Visits: 29
Hi Thanks for the quick reply, the answer is yes, I did use Sql Server Authentication and the authentication method was mixed logon; SQL Authentication and Windows Authentication were allowed
Thanks
Post #819807
Bru Medishetty
Bru Medishetty
Posted Monday, November 16, 2009 11:04 PM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 9:03 AM
Points: 1,427,
Visits: 1,506
can you post the exact error message or error picture as an attachment??
Bru Medishetty
To get quick answers read the article
How to post data/code on a forum to get the best help
My Blog -
learnsqlwithbru.com
Post #819823
k_amalpasha
k_amalpasha
Posted Tuesday, November 17, 2009 8:05 PM
Grasshopper
Group: General Forum Members
Last Login: Sunday, November 22, 2009 10:39 PM
Points: 13,
Visits: 29
Hi The Error is as follows:
TITLE: Connect to Server
------------------------------
Cannot connect to KAMAL\SQLEXPRESS.
------------------------------
ADDITIONAL INFORMATION:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Post #820529
Elliott W
Elliott W
Posted Tuesday, November 17, 2009 8:07 PM
SSCrazy
Group: General Forum Members
Last Login: Today @ 3:16 PM
Points: 2,406,
Visits: 1,869
Have you checked the windows firewall to make sure it isn't preventing connections?
CEWII
--------------------------------
Having trouble figuring out what jobs are running in SQL Server at the same time.
Try
Sql Job History Visualization
It lets you view your SQL Job history on an Outlook style calendar..
Post #820531
Bru Medishetty
Bru Medishetty
Posted Tuesday, November 17, 2009 8:23 PM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 9:03 AM
Points: 1,427,
Visits: 1,506
You have mentioned that you tried disabling the windows firewall and the Server\instancename to connect.
Can you check the IP Address and the Port No and use it conjunction as IP Address,Port No
Something like this 192.168.1.110,2433
Bru Medishetty
To get quick answers read the article
How to post data/code on a forum to get the best help
My Blog -
learnsqlwithbru.com
Post #820534
« Prev Topic
|
Next Topic »
29 posts, Page 1 of 3
1
2
3
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2010 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
