HI
I have installed VS 2005 with that SQL express edition came default and i then installde SQL server Enterprise Edition .....There i created database and tables and other my colleagues are not able to connect to the Database from there System...........I am using This on XP.......Is it possible to access databse from other remote systems .....IF yes What is the procedure to connect from my other computer to my database which is on XP not any Server OS..
Here is my environment and problem: I have VWD 2005 and SSE 2005 installed on my local machine. I also have these installed on my Windows 2003 Server. I developed my database using SSE on my local machine but pointing to directory on my server. I have been developing the web app using VWD on my server. I now want to use VWD on my local machine and point to the project on my server. I am able to open the project. In order to access the database in the "Database Explorer" I use as my "Data Source", "MS SQL Server (SQL Client) and it attaches fine and I can see my tables and data. Now for my problem: When I try to run the application "VIew in Browser", which login.aspx page is my first page, I get the page, but it doesn't inherit my master page which has the basic navigation and layout. Then after I try to login I get this message. The file "W:BBAppApp_DataTimeTracker.mdf" is on a network path that is not supported for database files.An attempt to attach an auto-named database for file W:BBAppApp_DataTimeTracker.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. Here is a portion of my web.config file for the connection string.<connectionStrings> <remove name="LocalSqlServer" /> <add name="LocalSqlServer" connectionString="Data Source=.SQLExpress;Integrated Security=true;AttachDBFilename=|DataDirectory|TimeTracker.mdf;User Instance=true" /> My website I started with the source code for the TimeTracker start kit and have added more pages and changed the sitemap. In general I guess I need to know how to handle using VWD on my local machine, but accessing the project on the server. The reason I'm doing this is because my colleague needs to be able to access the web app too to add pages to the site. Thank you for any help.
Hi, I have been creating a web store, which we will be hosting on our Windows Server 2003 system. I am also writing a windows application that will be running on our client systems on the same network/domain. I have no need to allow internet access to the database, just within our domain. Pretty much the windows application will be running and whenever a customer places an order, the program will automatically pop-up the needed information for our credit card processing, and shipping department. So far I have been able to establish a connection to our server by creating a data connection under the server explorer. However, it does not list any databases whatsoever, the web site has been published using Visual Studio 2005 Professional on the server, and is in 100% working order. I have searched and haven't found anything concrete on this, i'm sure its just something simple that im missing. It appears that the server is definetely connected to the database (since the website is fully functional), but it is not listing the information for other systems to access it. If anyone has any ideas, please let me know. Thank you
I have a SQL Server 2005 database (called BDHSE) in a PC which i call PC1. I have a second PC (PC2) and both are within a network (a WLAN).
What i want is to have access to BDHSE from an application in VB6 (APP1) running in PC2. All the INSERT, DELETE, UPDATE records process is done through APP1.
APP1 ia currently running in PC1 and is to be installed on PC2.
I have these questions:
1. What do i need to install in PC2 since all the INSERT, DELETE, and UPDATE is done using APP1? I guess i only have to install the Microsoft SQL Native Client (with all the prerequisites of course) but i am not sure.
2. In the APP1 made in VB6, do i have to change the connectionstring since i am accesing the database which physically is at PC1 and the APP1 will be used in PC2?
3. Any advice you can give me on doing this will be well received.
My database stays in a remote site and I have access it through VPN. I would like connect my current Windows based Asp.Net application with this database. What are my options? Can I connect remote database with SqlDataAdaper, will that be slow? Should I sue Web Services to connect database?
I am running the SQL express advanced on the same PC that also hosts my Visual Basic Express application. I have user instances turned off and full-text enabled and working from within a SQL query window. However, I can not create a working connection to the database using the data source wizard from the server explorer within VB.NET. Since this is on the same PC, do I need to enable anything other than shared memory? I get the error: Provider SQL Network Interfaces, error 26 Error locating server/instance.
I'm trying to adminster a remote MS SQL server from inside my company's firewall. I have the correct permissions to pass traffic through the firewall, but I need to authenticate to it first. When I try to register this remote SQL server through Enterpise Manager, it of course does not let me because of the firewall. Is there any way I can pass the firewall ID and password during the server registration process, and then pass the SQL server ID and password? I'm no SQL server expert by any means, but it doesn't look like it's possible. Are there any third party utilities that may accomplish this?
I am trying to look at a friends database that they have developed. Not having used SQL Server Express before I am experiencing problems trying to remotely connect to their database.
He connects locally just fine of course.
I get the error message about remote connectionsand the default settings so I have enabled TCP/IP and Named Pipes as well as cleared SQLSERVER Express in my firewall settings. I also stopped and restarted the service, but still get the same error message.
My connection parameters are like:
Server type: Database Engine Server name: http://sql.exampledatabase.net (should http be here? have tried with and without same error) Authentication: SQL Server Authentication (windows authentication? If so, how do I change to such?) Login: http://username (should http be here? have tried with and without same error) Password: password
TITLE: Connect to Server ------------------------------ Cannot connect to http://sql.exampledatabase.net
ADDITIONAL INFORMATION: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)
WORK2 - My workstation (xp pro) WORK3 - Location of SQL Express 2005
WORK3COMPANY sa,password
WORK3 is a XPPro, both WORK2 and 3 have full admin rights to their machines and the network, I am using SQL Authentication (sa, password) I have used the SQL Server Config app to enable the 4 Protocols, then restarted service. I can connect locally to my database via "SQL Server Management Studio Express", and through my VB application. I have checked "allow remote connections" in the database properties. I do not know what i am missing? any thoughts?
hai, I am working on ASP.NET 2003 with SQLServer2000. My application requires to be connected to the Database which is there in my Headoffice. My SQLServerName is "MyDBServerTestDB" Database Name is "WebTO", UserID="******" and Password="******" My Remote Server IP Address is "192.168.1.2" and its Static IP is "58.93.61.235" I have specified the Connection string for my Remote Server as "Provider=SQLOLEDB.1;Server=58.93.61.235TestDB;UID=******;PWD=******;Database=WebTO" (or) "Provider=SQLOLEDB.1;Server=58.93.61.235TestDB,1433;UID=******;PWD=******;Database=WebTO" (1433 is the Port number of the Remote SQLServer) but it is giving the error " SQL Server does not exist or access denied". if i execute the same application at my Headoffice (Remote Server) by changing the Connection string as "Provider=SQLOLEDB.1;Server=192.168.1.2TestDB;UID=******;PWD=******;Database=WebTO" then, it is working fine. Can anyone tell me where i went wrong or what i have to specify in my Connection string so that i can access my Remote Database Server. Thanks in Advance, Srinivas.
Hi, I have an ASP.Net web application running in groupnamewebservername. I am trying to connect it to the remote database server groupnamedatabaseservername using the ASPNET user id. The remote database is SQL Server 2005 and the web server has IIS 6.0 installed. My web.config connection entry has username as "groupnamewebservernameaspnet" and I have a database user in remote database server under the login name groupnamewebservername$. When I try to connect, I keep getting the following error: System.Data.SqlClient.SqlException: Login failed for user 'groupnamewebservernameaspnet'.
Could you please let me know what I am doing wrong here? Thanks. Regards, Gayathri.
I have two machines, the one has Windows 2003 server and the other has Windows Xp Pro on.
The 2003 one has SQL Standard Edition 2000 on where as the XP Pro has MSDE 2000.
I'm trying to run a windows based app from the 2003 server and it connects to a database on the XP Pro PC.
When running the application i keep getting the following exception:
"A Transport-Level error has occured when sending the request to the server (Provider: Named Pipes Provider, error: 0 - The specified network name is no longer available)
After using Preformance monitor on the XP machine it seems that when the app starts and the user logins in it make a SQL connection but then the connection is lost then the exception pops up. then i click continue and try it again then it works, then a couple of secs when using the system it pops up again. The Performance Monitor Test shows that the SQL connection keep being lost. The network is fine. its has something to do with SQL and Named Pipes and stuff.
When running the app on the Xp machine and the Connection is made to the 2003 machine there is no problem.
There are other connection made to the Windows XP Machine but i doubt that it affects the app.
Hi, I've worked with SQL Server plenty but never in this specific manner. Hoping someone can shed some light.I have a webform on web server A that needs to talk to a SQL server database that web server B accesses via its web application. I do not haveany privelidged access to server B or the sql server it uses (no FTP to webserver, no remote access via Enterprise Manager to the SQL server). The Admin of Server B told me that I can use a DSN connection to talk to the SQL server database that the web app on server B uses. He emailed me the names of the SQL database tables AND a copy of the web.config from server B which shows the DSN implemented like this:<appSettings> <add key="dsn" value="data source=sql3.domainname.net;database=dbname;User Id=dbuserid;password=dbpw;" /> <add key="default_language" value="en" /> <add key="error_email_to" value="someone@domainname.com" /> <add key="baseHref" value="http://www.mysite.com/" /> <add key="website_name" value="$$$$$$$$$$$$$$$$$" /></appSettings> I was planning to run my webforms on Server A where I do have FTP, Control Panel, etc.So, I wrote this code into my VB.NET codebehind file. Dim oODBCConnection As OdbcConnectionDim sConnString As String = _"Driver={SQL Server};" & _"Server=sql3.domainname.net;" & _"Database=dbname;" & _"Uid=dbuserid;" & _"Pwd=dbpw"oODBCConnection = New Odbc.OdbcConnection(sConnString)oODBCConnection.Open()... commands to access data and load something into a control on a webformoODBCConnection.Close() When I attempt to run the webform in my browser from Server A. I'm getting this error:ERROR [08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. ERROR [01000] [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).The error is EXACTLY the same whether I place the appSettings section in server A's web.config or leave them out.I have obvious questions about the error like...Might sql3.domainname.net simply be refusing communication requests that don't come from the Server B domain?Might the sql3.domainname.net be setup so that I need to use another protocol (not tcp/ip)?Might my code need to be changed to support this type of connection (i.e. I didn't code it right)?I spent some time reading http://support.microsoft.com/kb/328306/en-us but I'm at a loss as to what the best course is to take for debugging this.Thanks in advance for any insight you can offer. Stewart
I would appreciate any help anyone can offer I am developing a web application that needs to access SQL Server. I have implemented forms authentication. My Sql server is on another machine and I am unable to connect because ASPNET is a local account. Is there a way around this, I really need to keep forms authentication and I am forbidden to place Sql Server on the same machine
Hi all, I am trying to connect to remote sql server in vb.net application. I am getting an error "login failed for user'abc' ". why am I getting this error, what could be the possible reason. any help will be appreciated.
Just want to know what I need to check to make sure the remote connection is configure properly other than "Enable the remote connection" for the server? what ports that need to open up if firewall is running on the Server Machine?
I tested with a remote user, it seems the application just hung there and wait.. wait.. it seems something block the connection.
No error message, If I ping from the remote PC to the server, the response time is in acceptable range.
hi i added 2 databases to my SQL server on a machine next door using Microsoft SQL server management studio express... I made sure that the server allows remote connection
then from this computer i pass a connection string to my SQLCLient in VB2005 that looks a bit like this
Code: ( text ) ConnString = "Server=USER-PTDH8Z5ESHSQLEXPRESS;Database=FSS.MDB;Trusted_Con nection=True;User Instance=True"
for which it gives me this error when i open the connection SQLConnecton.Open()
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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.Att emptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.Log inNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) at System.Data.SqlClient.SqlInternalConnectionTds.Ope nLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ct or(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateC onnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.Creat ePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateOb ject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCrea teRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConne ction(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Flying_School_Scheduler.DBEngine.StartConnection() in
whats the big idea? i'm in a bit of a tight schedule here... can anyone help me here?
We have a database on a shared SQL Server stored on our ISP's server. I canconnect to this via Enterprise Manager from our office, but when I try thesame from Enterprise Manager on my PC at home I get the following message:A connection could not be established to MFSERVER.Reason: SQL Server is not running or access denied.Any ideas?Thanks
hi I am developing a web application using C# and SQL Server 2000. It works fine when the Application and DB are in same machine. Now I want to connect to the DB located in another machine in the same network. I used the connection string as follows. "Data Source=ip add,1433; user id=uid; password=pwd;"
"Data Source=machine name; user id=uid; password=pwd;"
but the appliation always throws the 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
what is the problem in the connection. Do I need any special configuration that has to applied on the DB machine. Anyone pls give a solution ASAP.
I am trying to connect to the SQL Server 2000 installed on Windows 2003 Server using VB .Net SQL Connection Class. I am getting an error
Error: An error has occured 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Hi,I trying to connect to the sql server in the network. The sqlserver is in the machine called "pinnacle". I am Using the following connection string to connect and i am getting the error "Sql server does not exist or Access denied"Public databaseConnectionStringSQL As String = "Data Source=(pinnacle);Initial Catalog=cms;Trusted_connection=True;User Id=dbuser;Password=password"Any help will be appriciated.Reagrds,Thiyasoft
Dear All,I have TWO PCs, one of them having SQL Server 2005 Expressi get sure the TCP is enables , Active, Remote conneciton is enabled via TCP onlyfrom VS2005 (C#) i can add new sqlconnection contorl and configure it with any of the installed DBsbut when i got to the Other PC with VS2005 as well, i can't configure itall i can do is to see the server inthe server list.. but NO databases are retieved at all in the Select database drop down menu any solution or suggestion
Hi, I have an issue with ASP.NET 2.0 and SQL Server 2005 My project when hosted in a machine its working, but in case of some other machine it is throwing 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)I have turned off my firewall and network configuration for sql server and its also done as tcp/ip and named pipes…though it is not working … The surprise is if I run using IDE its running , in the same machine after hosting it is not running, where the db is in another machine. What could be the problem? Any suggestions would be highly appreciated. Regards,Naveen Regards, Naveen
I know this is strickly not a website question, but dunno where else to post...To remotely admin and monitor some functions of the website, I wish to use a local application to connect to the MSSQL DB which is held on the remote webhosting serverI have the following code: Dim StrSQLUN As String = "[UN]" Dim StrSQLPW As String = "[PW]" Dim StrServer As String = "[IP][INSTANCE]" Dim StrDB As String = "[DB]" Dim strTimeOut As String = "Connection Timeout=0;" Dim pStrSQLConn As String = "Server=" & StrServer & ";Database=" & StrDB & ";User Id=" & StrSQLUN & ";Password=" & StrSQLPW & ";" & strTimeOut
Dim sqlConn As New SqlClient.SqlConnection(pStrSQLConn) If sqlConn.State = ConnectionState.Closed Then sqlConn.Open() This has basically been take from the existing code on the website, but changing to the server details. I had just started dev'ing this app when the admins decided to move the SQL server over to a different server. It was working on the old one, but the new one doesn't. It just times out after whatever time you put in the timeout variable. 0=unlimited, and so just sits there.I am also using the MSSQL Server Management Studio locally to connect to the same database, and although slow, does connect after about a minute or so. I thought they would be using the same type of underlying connection to access the server and database? Is this correct? Can they put restrictions in place for this specific sort of data access?Does anyone have any suggestions on how to resolve this issue??Thanks for any helpAdam.
Sub Page_Load(Src As Object, E As EventArgs) Dim MyConnection As SqlConnection Dim da AS sqlDataAdaptor Dim ds As DataSet MyConnection = New SqlConnection("DSN=***;UID=***;PWD=***") da = new sqlDataAdaptor("select * from city", MyConnection) Try MyConnection.open() Response.write "Connection Success " & MyConnection.Database & "<br>" catch sx AS sqlException Response.write "Connection successful: <br>" End Try
ds=new Dataset() da.Fill(ds, "City")
With DataGrid1 .DataSource = ds.Tables("city").DefaultView .DataBind() End With
Hi all, I am new to SQL Server but I'm trying to learn it.. :) I've created a database on my campus server. Now I want to configure it so that I can access the database from my laptop computer through internet. I have an account in the SQL server installed on my remote server. I can connect to the remote server through remote connection.
hi sql team i've been reading much of the ms walkthroughs and some forum how they solve sql server 2005 (express) remote connection but non of them squared my problem.
in my case since we dont have in-house web server i need the script (ASP) run from our domain host/hoster and the sql database will be somewhere in our office. i try making a local (LAN) run of script just to test if the connection (asp-to-sql dbase) was established and im getting all things work.
OUT PUT http://images.cjb.net/114e8.gif http://images.cjb.net/343e3.gif
problem/nightmare comes when i access the test script through domain host with error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.
i tried using the following connection string thinking it will work for me but nothing seems happen:
I have a software to connect the SQL Server as DB, and it is ok to connect to the SQL Server 2000 on the remote server in our firm, but got errors when doing the connection to the SQL Server 2005. the error messages are: Error #1: ADO Error #-2147467259 Description SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. Source Microsoft SQL Native Client Error #2: ADO Error ##-2147467259 Description An error has occurred while establishing a connection to the server. When connection to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. Source Microsoft SQL Native Client Error #3: ADO Error ##-2147467259 Description Login timeout expired Source Microsoft SQL Native Client
I'm using SQL Server 2005 version 9.00.1399.00, not the Express version. Should I update the SQL Server 2005 Network Configuration in SQL Server Configuation Manager? But I don't know what should be set to "Enable" or Disabled". Is any other place need be configured?
i use connection to connect to a remote sql server.Here are the details provider :Native OLE DB/SQL Native client Server :ip address databaseelect respective database authentication ql server
i have a problem and it comes up with this message
"Test Connection failed because of an error in initializing provider.Login timeout expired.An Error has occured when establishing a connection to the server .when connection sql server 2005 database,this failure may be caused by the fact that under default settings sql server does not allow remote connections"
i also review the ff post for client and server trouble shooting tips: http://blogs.msdn.com/sql_protocols/archive/2006/09/30/SQL-Server-2005-Remote-Connectivity-Issue-TroubleShooting.aspx
I have installed SQL server 2005 express on my main server.
It has been installed with windows authentication.
I can use sqlcmd -S machinenameinstancename to connect to the server, but when I try to connect from another machine on my lan, I get the error about user not part of trusted sql connection msg 18452 level 14 state 1
I have tried using a windows username and password from my server to access it but that fails also.
