November 16, 2009 at 8:10 pm
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
November 16, 2009 at 9:09 pm
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).
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 16, 2009 at 9:40 pm
Windows Firewall?
CEWII
November 16, 2009 at 10:08 pm
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.
November 16, 2009 at 10:14 pm
Did you use SQL Login? and check the Authentication mode.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 16, 2009 at 10:18 pm
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
November 16, 2009 at 11:04 pm
can you post the exact error message or error picture as an attachment??
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 17, 2009 at 8:05 pm
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
------------------------------
November 17, 2009 at 8:07 pm
Have you checked the windows firewall to make sure it isn't preventing connections?
CEWII
November 17, 2009 at 8:23 pm
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
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 18, 2009 at 2:42 pm
Hi,
the IP Add. for the Computer with the local instance of SQL Server installed is: 192.168.1.2
The Port is:1433
I have tried to login with:
ServerType: Database Engine
ServerName:192.168.1.2,1433\SQLEXPRESS
Authentication:SQL SERVER AUTHENTICATION
Firewall: Disabled
I still get the error I have posted (see:Post #820529)
Thanks
November 18, 2009 at 2:48 pm
k_amalpasha (11/18/2009)
Hi,the IP Add. for the Computer with the local instance of SQL Server installed is: 192.168.1.2
The Port is:1433
I have tried to login with:
ServerType: Database Engine
ServerName:192.168.1.2,1433\SQLEXPRESS
Authentication:SQL SERVER AUTHENTICATION
Firewall: Disabled
I still get the error I have posted (see:Post #820529)
Thanks
When you reference it by IP address and port you don't need the instance name.
Servername becomes: 192.168.1.2,1433
Firewall is disabled on the server side? Can any other machine talk to that server?
CEWII
November 18, 2009 at 4:09 pm
Oops, Sorry, I had only disabled the firewall on the client side and not the server side, now it is connecting.
I am however now encountering another problem, when I login using SQL Server Authentication into the management utility and I try to expand the database folder then I get "the database <db name> is not accessible (microsoft.SQLServer.Express.ObjectExplorer)"
Thanks
November 18, 2009 at 4:30 pm
Nothing to worry, the user you are connecting must not have permissions on that Database.
On the SQL Instance, see the permissions to that SQL login and if not given already grant the appropriate permissions in the User Mappings Page.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 18, 2009 at 9:55 pm
Thanks for that, I've got it to work, but now it always asks me for a password to connect to the server every time I reopen the front end on the client side.
Viewing 15 posts - 1 through 15 (of 28 total)
You must be logged in to reply to this topic. Login to reply