Problem Connecting Sqlserver2005 Express Remotely In LAN
Feb 11, 2008
i have a Vb application on an client pc that has to connect with a sql databse file on the server.
the connection string is :
connectionString="Data Source=<servername>SQLEXPRESS,1433;Initial Catalog=TBSD.mdf; User Id=sa;Password=sa;integrated security=false;" />
</connectionStrings>
if i run the application i get the error message : "login failed for user 'sa'.
If i try to connect remotely to sql server express with sql server managment studio express i can connect without any problems.
is this a security problem ?
View 5 Replies
ADVERTISEMENT
Dec 9, 2006
I'm new to MSSQL. At my work place, I'm using MSSQL and using SQL Query Analyzer to run queries and view all my database tables and structures.
Now, I can work remotely at home for the time being. So, how do I get SQL Query Analyzer and be able to connect remotely to my database at work?
I've downloaded SQL Server 2005 Express and it comes with SQL Server Management Studio, which looks similar to SQL Query Analyzer. The problem is though, how would I remotely connect to my database server at work? Is it possible to do this using SQL Server 2005 express?
One thing I was advised to do was configure the TCP/IP Port number from 1433 to 1435. However, I do not see an option to configure that nor do not know how to connect remotely (I do have the IP, User, and Pass).
View 1 Replies
View Related
Oct 12, 2007
Hi
I hope this is the right place for this question.
I'm using SQL 2005 Express on my local machine, I can connect and do all I need to.
But when I transfered my database to my remote server I cannot connect (I changed the connection string to suit).
<add name="ClubSiteDB" connectionString="Data Source=xx.xxx.xx.xx,1786;Network Library=DBMSSOCN;Initial Catalog=xxx;User ID=xxx;Password=xxx;" providerName="System.Data.SqlClient"/>
I have checked the connection string passsword etc, and all are correct.
I have tried SQL Server Management Studio, aspnet_regsql.exe etc and all give the following error:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - No such host is known.)or
System.Web.HttpException: Unable to connect to SQL Server database. ---> System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)
I have used the surface config to enable TCP/IP and named pipes.
Any Ideas?
Thanks
View 4 Replies
View Related
Sep 8, 2007
I've been trying to configure remote connections to my sql server express to no avail.
First here are some constants to clear some things up:
- OS: Windows XP Pro
- SQL Express version: April CTP release
- Windows Firewall: disabled (to avoid any problems there)
- Network type: two computers connected a router.
- Router firewall: Enabled (I may be wrong but the router firewall only blocks external traffic, so I left it on.)
First, I configured my SQL server to allow remote connections in the SQL Surface Area Configuration. (Set it to both TCP/IP and named pipes)
Second, I enabled and configured sql server browser.
Third, I enabled TCP/IP and named pipes in the 'Protocols for SQL Express' option of the SQL Server Configuration Manager.
According to http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx
I have done everything I need to (including edit the registry to enable the SQL Server Browser service) and the error I continue to get is:
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)"
So I tinkered and had no success in messing with anything that would fix it. Although, ***when I browsed for network servers on different machine, the server instance DID show up in the list***. So I find it odd that it can find the instance when browsing, but fails to 'find' it when making a connection.
So I didn't stop there, I decided to try the non-sql server browser method of remotely connecting: specifying the IP.
I went back to the blog of instructions referenced above and re-did the steps, this time specifying a TCP Port for the server instance and then after specifying the port on the remote computer connection string, and attempting to connect, I get this error:
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) (Microsoft SQL Server, Error: 10060)"
I've done all I know how, read all the possible blogs I can, and nothing's come up. If anyone can shed some light on me, I'd pay you 1 billion pretend dollars. Any help would be appreciated. Thank you!
View 2 Replies
View Related
Oct 10, 2006
Hi,
I am trying to connecting Eclipse to SQLserver2005 on Win2000, and the driver I use is JDBC.
My problem is: No matter what kind of authentification I try, it always throws out the exception of:
The user is not associated with a trusted SQL Server connection.
I tried 2 ways for connection: one is the windows, and another is Sql server authentification
To the window authentification, I appended Trusted_Connection=yes to the URL, and omit the user and password fields, and it failed. But even I used the user and password options, it didn't work, either.
To the Sqlserver authentification, I tried with the user and password, but it failed. Before that, I also added the user account in the Security option and for the specified Database.. while failed again.
And also for example:
when using the windows authentification, I tried this:
String SERVANDDB ="jdbc:sqlserver://localhost:1433;DatabaseName=TestDB;Trusted_Connection=Yes";
....
con = DriverManager.getConnection(SERVANDDB);
This throw the exception of user' ' is not a trust_connection....blabla
when using the sqlserver authentification, I tried like this:(the user ABC is assigned authority to database TestDB)
String SERVANDDB ="jdbc:sqlserver://localhost;DatabaseName=TestDB";
String USER = "ABC";
String PWD = "CBA";
con = DriverManager.getConnection(SERVANDDB, USER,PWD);
(The server is runing on my computer)
Thank you.
View 3 Replies
View Related
Oct 22, 2007
I have a sql server 2005 remotely, need to connect from client using sql management studio. I am unable to connect from one of the client machine and able to connect from different machine.
The tcp/ip, named pipes and sql browser is enabled in server and windows firewall is off in client.
I am getting (provider: sql network interfaces, error 26 - error locating server/instance specified)
Please throw your suggestions.
View 20 Replies
View Related
Oct 5, 2007
i have installed sql server 2005 standard on our server. i need to now connect to the server from a client machine within our network. do i need to install just the client tools? what are the other steps in connecting? im new to sql server, so thanks for the help.
andrew
View 3 Replies
View Related
Oct 11, 2007
I have SQL 05 and SQL 200o on same server . SQL 05 version is a named inatnce. But when i try to connect it from my computer first it doest show the name instance in the list and when i manulay write its name i got this error.
"A connection was successfully established with the server, but then an error occurred during the pre-login handshake. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.) (.Net SqlClient Data Provider)"
I went to check that remote connectiona nd SQL browsing is on or not but both were on . any ideas why this is happening and why the name is not coming in list of Server.
Thanks
View 2 Replies
View Related
Jul 24, 2006
Hi,
I am using osql to connect to my remote MSSQL server. I am able to get a prompt for password and telnet to 1433 just fine, so I conclude this is not related to firewall. When I try to connect I get:
C:Program FilesMicrosoft SQL Server80ToolsBinn>osql -S xx.xx.xx.xx -U test
Password:
[DBNETLIB]SQL Server does not exist or access denied.
[DBNETLIB]ConnectionOpen (Connect()).
When I try to connect from 'localhost':
C:Program FilesMicrosoft SQL Server80Toolsinn>osql -U test
Password:
1>
--
This is Microsoft SQL Server 2005 - 9.00.1399.06 and both local and remote connections are allowed. Logs don't show up anything.
Thank you.
View 21 Replies
View Related
Oct 23, 2007
I have a sql server 2005 remotely, need to connect from client using sql management studio. I am unable to connect from one of the client machine and able to connect from different machine.
The tcp/ip, named pipes and sql browser is enabled in (sscm)server and windows firewall is off in client.
I am getting (provider: sql network interfaces, error 26 - error locating server/instance specified)
Please throw your suggestions.
View 4 Replies
View Related
Jun 8, 2007
Hi,
I have 2 machines using SQL Server 2005 developer edition. I am able to connect to each of them locally without any problem. But when I try using one SQL Server as server and another machine's SQL Server as client, I am not able to connect. I get the following error:
TITLE: Connect to Server
------------------------------
Cannot connect to ServerName.
------------------------------
ADDITIONAL INFORMATION:
A connection was successfully established with the server, but then an error occurred during the pre-login handshake. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233).
I have checked for "Allow Remote Connections" property turned on for TCP/IP.
I am using SQL Server Authetication mode.
I have checked for SQL Server Browser service to be running.
Firewall on the server is also allowing the sql server traffic to pass.
But still not able to connect. What could be the problem connecting the 2 machines.
Any help is appreciated.
View 4 Replies
View Related
Sep 20, 2007
New sql2005 install as a named instance and having trouble connecting from remote machines.
I noticed on our other servers that the "Public" server role is listed in permissions (right-click over the sqlmgr connection for the dialog, then permissions).
When I try to add the role to the new server it doesn't save! This is the only setting that's different, can't connect using sqlmgr from other machines to this server so any ideas on other settings to look at appreciated.
View 6 Replies
View Related
Sep 14, 2007
hi. im still a bit new in handling SQL and im having problems connecting to a remote sql server 2005. i have already configured the surface area to accept remote connections and am using the connection string:
SqlConnection lasConnection = new SqlConnection("user id = sa;" +
"password = 12345; server = Naomi;" +
"Trusted_Connection = yes;" +
"database = LAS;" +
"connection timeout=30");
and it returns an error of "System.Data.SqlClient.SqlException: Login failed for user 'NAOMIGuest' "
however, when i use the application on the same computer as the server, it has no problems connecting at all. could please point me to the right direction on how i should face this problem?
thanks in advance
View 5 Replies
View Related
Jan 10, 2006
Hello,
Only the server administrator user can connect to SSIS from remote workstations. All other users encounter "Access denied". What security settings are necessary to permit regular user access to SSIS? Firewalling is not an issue. SSIS is running and works fully for the server administrator user. All users can manage the Database with SSMS just fine; only SSIS cannot be accessed by regular users.
Server Configuration Notes:
Windows Server 2003
SQL Server 2005 Standard
Workstation Configuraiton Notes:
Windows XP Professional
SSMS (installed from the SS2005 media)
Thank you.
View 7 Replies
View Related
Oct 20, 2006
Hi
I have installed SQL Server 2005 onto a server and then on my client machine I have installed SQL Server 2005 and the Server Management Studio.
When installing it on the server I chose all the defaults so have not setup an sql username or password to connect as I thought I could use Windows.
I go to the Server Management and registered servers, create a new one and enter the ip address of the server and choose Windows Authentication. The following error keeps appearing though and I am not sure what settings/where to check:
Login failed for user ''. The user is not associated with a trusted SQL Server connection. (.Net SqlClient Data Provider)
I have checked and think port 1443 is open on the server, tcpip is enabled but when I choose Windows authentication I cannot enter a username or password as it is greyed out. It has completed the username but no password and these are not the correct ones to connect to the server - I wish to wish the same one I use for RDC.
Or should I try SQL Authentication and if so how would I set this up? Cannot see on the server in SQL Configuration where I could set this?
Hope someone who knows a lot more than me on this can help!
Thanks for your time - this has been driving me mad for days now and everything I print off the internet is not help so any feed back or more useful links to loo up would be great.
View 4 Replies
View Related
May 26, 2007
hello,
i am trying to connect to Analysis services server through another pc but i am unable to do so.
Using the following commands i manage to connect to analysis services server at my pc
Server.srv=new Server ();
srv.Connect('ip address or name');
but not to another pc. Are there any settings under sql server should i change ?
View 12 Replies
View Related
Apr 20, 2006
We have merge replication, Publisher work on SQLserver2005
standard edition,
Subscriber work on
SQL Express. My problem is following.
Considering that the Subscriber is on SQL Express we can use
only Merge replication.
Is it possible to develop merge replication to replicate
data only from Subscriber to Publisher.
View 1 Replies
View Related
May 12, 2007
hi
COMPUTER-1
IP ::::: 129.100.100.5
COMPUTER NAME IS ::::: HASH
MEMBER OF DOMAIN
in this computer sqlserver express edition is installed, i want to remove this express becoz in configuration manager it show two SQLSERVER'S are running. when i browse from COMPUTER - 2 for network servers it show server name as HASH/SQLEXPRESS, but not the main SQLSERVER.
COMPUTER -2
IP::::129.100.100.142
COMPUTER NAME::: FEROZ
MEMBER OF WORKGROUP
can anyone help me how to connect these two computers and remove this express edition
iam new to sqlserver configuration
thanks in advance
waiting for eager reply
View 1 Replies
View Related
Sep 27, 2006
Hello all,
I am having trouble getting SQL Express 2005 on Windows Server 2003
working remotely. I have set it up for TCP connections and all,
and I can connect to the server fine, but I am unable to login. How do
I go about creating accounts for the db that will allow me to access it
remotely?
View 1 Replies
View Related
May 18, 2005
I have SQL Express April CTP (from VS Beta 2) installed on machineA, but I cannot connect to it from machineB using the command "sqlcmd -S machineAsqlexpress -E". This command works just fine from machineA.
View 7 Replies
View Related
Sep 19, 2007
I hope helps some folks. I hope the links come through okay.
Keywords: Help, Network, KB910437, SQL Express, Network, TCP/IP, User,
SQL Server Express Networking
After a long period of trial and error I finally figured out how to connect to SQL Server Express 2005 using SQL Authentication across an XP network. It required several rather involved several steps to do this. I wrote this document just in case I forgot what I did so that I could repair or re-create my network login(s).
I will try to summarize the steps and include some HELP links to the web pages or my local €œSQL Books On Line€? pages that pointed me in the correct directions. The final piece to my puzzle was found here on the MSDN forums. Some links are better than others, while others may appear not to apply, so always check for links at the bottom of pages. Some were the best I could find after the fact, and not my original pages. Others were actually better, and may seem to be redundant. It€™s a work in progress.
I left out many routine or obvious steps like telling you when to click OK. If you need to be told when, you have no business even considering trying this. Good Luck!
PREREQUISITES:
1. You must have an instance of SQL Express installed and running.
2. You must have the SQL Browser service running.
3. You must have SQL Management Studio Express, SMSE, installed on your Server and to be able to log in as an administrator using Windows Authentification. Be familiar with Object Explorer under SMSE.
4. You must have SQL Server Surface Area Configuration properly installed.
5. You must have a functioning LAN, such as a Windows Workgroup.
6. You need a second computer on your LAN running SMSE Tools for testing.
7. You need a strong knowledge of how to use Control Panel.
8. You need to have KB910437 properly installed despite what this might say, although a neat diagnostic command is documented to verify your install.
SUMMARY:
You must enable SQL Networking
You must configure SQL TCP/IP for the server instance.
You must configure the server instance to use UDP Port 1433.
You must enable a UDP port in your Windows Firewall for that server instance.
Test the ability to remote log in using Windows Authentification using SMSE.
You must create a Windows User account for SQL.
You must create a SQL User login Auditing for that Windows User account.
You must grant Permissions to do things for that SQL login.
Now you can try to Log In across a network.
DETAILS:
SQL Networking must be setup by using the SQL Configuration Manager, SCM.
The default installation leaves networking disabled.
Select and use the TCP/IP protocol.
Re-Start the SQL Server service.
Using the SQL Server Surface Area Configuration Manager you must enable TCP/IP.
Select €œServices and Connections€?.
Choose your server instance and then select €œRemote Connections€?.
Choose €œLocal and Remote€?, then €œUsing TCP/IP Only€?.
Re-Start the SQL Server service.
The server needs a means to talk to the outside world. Use SCM.
Setup your IP address by right clicking on the TCP/IP protocol
Choose €œProperties€?.
On the €œProtocol€? tab leave the default settings, (Yes, 30000, Yes, No).
Select the €œIP Address€? tab.
Configure €œIP1€?, (Yes, Yes, enter your IP address, 0, blank).
Configure €œIP All. Leave the default alone.
Enter €œ1433€? on the second line.
Re-Start the SQL Server service.
The server needs to unlock the door to the outside world.
Open Control Panel and select Windows Firewall.
Click the €œExceptions€? tab and click on €œAdd Port€¦€?.
For €œName€?, enter the name of the server instance.
For €œPort Number€?, the same port as Step 3, 1433.
Test to see if Windows log in works before enabling SQL Authentification.
Using the SMSE, select the €œConnect€? icon in Object Explorer.
Accept all defaults and see if it works.
The server needs Windows user accounts setup.
Set up a generic user account for SQL remote users.
I suggest setting up an account for administrators to use.
I suggest setting up an account for general users to use.
SQL needs to add Windows users to SQL Logins.
Convert a windows user login to a SQL login manually or automatically.
The user needs to be assigned tasks that he is permitted to perform.
Grant the user limited access, or just enough.
Assign generic logins to groups, and then assign permissions to the groups.
Use the pre-defined groups. By assigning users to groups.
Test to see if SQL Authentification works locally, then remotely.
Using the SMSE, select the €œConnect€? icon in Object Explorer.
View 6 Replies
View Related
Dec 15, 2006
Hello,
I'm using a Windows XP Home laptop to connect to a network of one of my customers. The administrator of the customer has given me a username and password for a VPN connection. I've got the VPN connection working and I can ping the SQL Express server.
This server is using Windows Authentication. For the users of my VB application we have added a group to the Active Directory and added this group as a user to the SQL Express Server. This works and the users can access the database from within the application. The SQL Express Server allows remote connections and the browser service is also running.
I would like to use the SQL management Studio Express on my laptop to access the remote SQL Express server and manage the database files. To do this I first connect to the remote LAN using VPN and add the address of the SQL EXpress server in the field 'Server name' of the 'Connect to server' screen. The authentication field is set to Windows Authentication. However the username is greyed out and states the login for the SQL Express server on my laptop: laptopusername. How can I correct this?
I don't know whether the username of the VPN connection is in the Active Directory. Should this be the case and should this user also be added to the login/user of the SQL Express server? And how do I get the Management Studio to connect to the remote server? Could XP Home be the bottleneck as it cannot logon to a domain?
Anyone any ideas?
View 2 Replies
View Related
Jun 18, 2001
I had asked a question last week and I realized that I had phrased it in a misleading way. Within a lab environment at my company, we are experimenting w/ accessing remote SQL data files stored separately on another machine from the SQL server itself (whether it be another client or server).
The experiment is this: You have one client machine accessing a SQL server via Enterprise Manager. The datafiles that you are trying to access are stored on another machine that does not have SQL Server installed. This remote machine only has the datafiles.
Can one map a static path via UNC from the SQL server to the datafiles on the remote machine and then access these datafiles (as long as the user's account has the appropriate permissions to the remote machine)? To my understanding, within SQL server you can only access datafiles that are stored locally on the SQL server itself.
The other thing that I was wondering was if the type of user account had some significance in this situation. More than likely, a local user account would not be able to access the remote machine w/ the datafiles even if the SQL server could map an UNC path and retain it. A domainuser account might be able to do this though.
Any help that you could provide would be appreciated.
View 5 Replies
View Related
Nov 17, 2006
Since today (after installing the latest Windows Updates !on my local machine!) I cannot login to a SQLExpress instance remotely; stating that it cannot find the server/instance.
The weird thing is: it only happens when I want to login to the non-default instance (sqlexpress 2005) (<IP><instance>).
When i'm using the default instance (msde 2000 or sqlexpress 2005 on another machine) (<IP>) it seems to work fine.
Does this have something to do with the windows updates, or is it just a coincedence?
Thanks in advance,
Remco Ros
View 4 Replies
View Related
Oct 5, 2007
im using sql server 2005 express for my vb.net projects but i can't connect to it using SQL Server Management Studio Express or through my vb.net code. I got a error message: An error has occourred while estabishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. I already enabled remote connections as suggested by this site http://www.programmingado.net/a-395/SQL-Server-2005-Express-and-remote-connection.aspx. Made sure that SQL Server and SQL Browser services are running. But I still cant connect.
View 4 Replies
View Related
Jul 24, 2007
I am tring to access the SQL 2005 Express which installed in remote machine. Front end app is on Visual Studio 2005. Try to connect SQL Express using the application Layer which is installed on the computer where SQL Express is installed. Could not fetch data from the SQL Express. What could be the problem?
With Regards,
ADK
View 1 Replies
View Related
Jun 23, 2006
Hi all,
I'm just wondering if there is documentation anywhere to help me with installation of SQL 2005 Express on a remote computer. I've set up IIS 6.0 and Windows Server 2003 Web Edition on another computer and am planning to use that for a development server.
Currently I've already installed VWD Express (local computer) and SQL 2005 Express, as well as SQL Query Manager (remote computer). But I seem to be having problems with VWD being able to create databases when i edit the code remotely.
For example when I right-click on "Data Connections" in the "Database Explorer" to create a new database it won't let me. The only way I can do this is to add a connection to a database which I have previously created. And even then there are still problems.
If I set up the database by adding a connection I cannot seem to create stored procedures. The error message I keep getting is "This feature is not supported in Visual Developer".
Is this due to wrong settings whilst installing SQL Express? Or am I just not configuring it right?
Any help on this issue would be greatly appreciated.
Thanks.
View 5 Replies
View Related
Mar 18, 2007
I've just bought a Virtual Private Server Account because I want to host a number of different ASP.NET sites, each backed by their own SQL database. I've downloaded SQLEXPRE.EXE and SQLServer2005_SSMEE-x64.msi to the server and installed the database engine and Management Studio Express on the VPS.
My problem is that I cannot access the SQLEXPRESS on my server from my local machine. The Management Studio Express cannot get logged in. I've used "Surface Area Configuration Manager" to allow "Local and remote connections" using TCP/IP only. I've used SQL Server Configuration Manager" to enable the TCP/IP protocol. After making these changes I've stopped and started the SQL server - and even rebooted the machine. I've created a login "Remote User" for this access. I've added sqlservr.exe as an exception to the firewall.
What else do I need to do? Is there a simpleton's guide to completing this task?
View 1 Replies
View Related
Jun 22, 2007
I have read all of the posts regarding this subject as well as 3"Dummies" guides and I keep having the same problems. I have a verysimple multi-user application that has to hit a database. Wecuerrently have this system deployed and it is working fine on adomain based network. We are scaling back and the network we will beusing is now a workgroup not a domain.It should be simple. I have XP boxes (clients) trying to hit the SQLServer Express database on a Windows Server 2003 machine. It is aclosed network so security is not an issue. I am trying to make thisthing wide open. All I want is for the user to be logged in on hisclient machine, run the application, and access/update the databasewithout having to re-authenticate to the SQL server. I want windowsto handle all of the authentication between the XP machines and theServer 2003 machine.Any suggestions would be greatly appreciated.
View 1 Replies
View Related
Oct 31, 2007
Hi all, I'm having a little trouble connecting to a SQLExpress instance on a remote domain using SQL Server Management Studio Express.I've read that by default the program is set up locally only, so have edited the Surface Area Configuration. It only gives me the option to edit 'Services and Connections' on the localhost, but have edited the Remote Connections to use TCP/IP and Named Pipes. In the Management Studio, I enter the server name, and login credentials. On the Connection Properties tab I changed the network protocol to TCP/IP though everytime I attempt to connect I get the following error message: Any help would be greatly appreciated. Rich
View 4 Replies
View Related
Jul 27, 2006
I have SQL Server 2005 Express installed on a windows server 2003 standard edition. I have configured the windows firewall to allow exceptions for sqlservr.exe and sqlbrowser.exe. I have enabled remote and local connections using tcp/ip & Named Pipes through the Sql Server Surface Area Connection utility. I am able to telnet into the server with: telnet <server ip> <1433>.
Here is the strange part: I am able to connect to the Sql Server remotely from a development machine via Sql Server Management Studio Express, but I am unable to connect to the Sql Server from the same development machine by registering it in Sql Server Enterprise Manager...Is it possible to register SQL Express through Enterprise Manager?
When registering the SQL Express DB in Enterprise Manager I tried both just the (IP Address) of the server and the (IP AddressSQLExpress) as the server/host but I am getting the following errors from enterprise manager:
Just the (IP Address) as the server/host:
Invalid Connection.
ConnectionOpen( Invalid Instance())
(IP AddressSQLEXPRESS) as the server/host:
Sql Server does not exist or access denied. ConnectOpen(Connect()).
Any idea why I can€™t register/mount the instance remotely in Enterprise Manager
but I can in Sql Server Management Studio Express?
Thanks,
Greg
View 1 Replies
View Related
Mar 4, 2007
Problem: I upgraded a SQL Server Express instance to SQL Server Enterprise, but I'm unable to connect to the SQL server from any remote machine. Only local connections work -- and I've verified that Remote Connections are allowed in the SQL Surface Confg. utility.
Scenario: Server1 has an SQL Enterprise edition installed as a default installation. SharePoint Server 2007 was installed later, and during that install a SQL Express edition instance was installed which is part of the standard SharePoint install. That Express instance contains all the SharePoint content databases.
So Server1 has SQL instances:
Server1 <default install running Enterprise>
Server1OFFICESERVER <previously running SQL Express, now upgraded to Enterprise>
After upgrading Server1OFFICESERVER to Enterprise, everything seemed to work fine (i.e. SharePoint works fine). However when I try to connect remotely to Server1OFFICESERVER I can't. I've verified through the SQL Surface configuration tool that remote connections are allowed. I've rebooted the server as well. I've tried connecting remotely using various PCs and various applications (e.g. SQL Server Mgmt Studio, Visual Studio, etc.).
Any other ideas to try?
View 4 Replies
View Related
Aug 20, 2007
Hi, I hope you can help.I have configured a Windows 2003 web server and SQL 2005 Server (on same box) to successfully allow remote connections and to allow access via SQL Server Management Studio Express 2005.The problem I have is that I want to restrict access to the databases on the server via the Management Studio to specific databases e.g. 1 database user "sees" only 1 database.I can configure it so that the user's remote access permissions do not allow access to other databases but they can still "see" the database listed in the Management Studio explorer.I can also configure it so that the users cannot see all the databases (by disabling View All Databases on SQL Server), but this means that they cannot not see their own database which they have permissions for.Is it impossible to have the desired behaviour of only displaying the database which the remote user accessing has permissions for and hiding all other databases?I have MSN'd,Googled and Yahoo'd this one to no avail :(Many thanksFergus
View 6 Replies
View Related
