Remote Access URGENT!
Apr 14, 2000Can anyone tell if we can access a remote sql sever 7.0, if we install sql server 7.0 standard edition on win nt work station with proper network WAN.
View 2 Replies
ADVERTISEMENT
Remote Access Server Configuration Option And Remote Query Timeout?
Jun 2, 2015- When I disable "allow remote connections to this server" from server properties>connection page, I can still remotely connect to the server from SSMS...so what is the impact of enable/disabling it?
- what is the impact of changing the remote query timeout (on the same page) from default value?
Urgent Urgent Please.(Access SQL Pass Through Queries)
Jul 6, 2000Hello,
I am facing a huge problem in my sql server database using access as a front end.The main problem is trying to execute queries "views" ,since they reside on sql server now,and using variables or parameters in reports and forms to filter on this query.
Ex.
how can the following be implemented using the same query but in sql server?
Access
------
SELECT MAT_Charts.YYYYMM
FROM MAT_Charts
WHERE ((([Area_Code] & "-" & [GROUP_CODE])=[Reports]![MAT_Chart_C1].[MAT_Key]))
GROUP BY MAT_Charts.YYYYMM;
It is specifically this statement in which I am interested:
[GROUP_CODE])=[Reports]![MAT_Chart_C1].[MAT_Key]))
Thank you very much for your concern.
#URGENT# Remote Connections To Server
Sep 22, 2007Hi, I've been trying all day to make connections to SQL server 2005 express work. I have gone throgh the setup of tcp/ip, firewall exceptions, and anything else possible. My problem is that after i have gone through the microsoft support pages.
I can connect to SQL server in VS2005 but i can connect and make changes to databases with SQL Server Management Studio. In VS2005 i try to connect and i get the error System.Data.SqlClient.SqlException
Message="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: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server)"
I have to write a program by the end of the week and cannot proceed without SQL Server working proerly. Any replies would be apreciated as i am so fustrated with this problem. I have included the full error stack below if it is required. Contact me for any more details
Regards
Matt
System.Data.SqlClient.SqlException was unhandled
Class=20
ErrorCode=-2146232060
LineNumber=0
Message="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: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server)"
Number=2
Server=""
Source=".Net SqlClient Data Provider"
State=0
StackTrace:
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(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.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at Tour_Operator.DataSet1TableAdapters.ToursTableAdapter.Fill(ToursDataTable dataTable) in C:Documents and SettingsMattyMy DocumentsVisual Studio 2005ProjectsComputermat-ITTour OperatorPrintDataSet1.Designer.vb:line 1332
at Tour_Operator.main.main_Load(Object sender, EventArgs e) in C:Documents and SettingsMattyMy DocumentsVisual Studio 2005ProjectsComputermat-ITTour Operatormain.vb:line 18
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.SafeNativeMethods.ShowWindow(HandleRef hWnd, Int32 nCmdShow)
at System.Windows.Forms.Control.SetVisibleCore(Boolean value)
at System.Windows.Forms.Form.SetVisibleCore(Boolean value)
at System.Windows.Forms.Control.set_Visible(Boolean value)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.Run(ApplicationContext context)
at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.OnRun()
at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.DoApplicationModel()
at Microsoft.VisualBasic.ApplicationServices.WindowsFormsApplicationBase.Run(String[] commandLine)
at Tour_Operator.My.MyApplication.Main(String[] Args) in 17d14f5c-a337-4978-8281-53493378c1071.vb:line 81
at System.AppDomain.nExecuteAssembly(Assembly assembly, String[] args)
at System.Runtime.Hosting.ManifestRunner.Run(Boolean checkAptModel)
at System.Runtime.Hosting.ManifestRunner.ExecuteAsAssembly()
at System.Runtime.Hosting.ApplicationActivator.CreateInstance(ActivationContext activationContext, String[] activationCustomData)
at System.Runtime.Hosting.ApplicationActivator.CreateInstance(ActivationContext activationContext)
at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssemblyDebugInZone()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
Please Help With Remote SQL Access
Jul 22, 2005Hi
I have a web application and SQL database on separate SQL 2000 server. I have no admin rights to these servers.The ISP gave me a VPN connection and password to manager my database.If i run the application from my home computer WITH the VPN connected the application works fine.However if i disconnect the VPN or try to run the application from the remote server i get this error:SQL Server does not exist or access deniedI have researched this problem extensively and CANNOT find a solution. The application and SQL 2000 database server are on different computers. The SQL user id and password are different from the VPN connection's.My web config looks like this:<?xml version="1.0" encoding="utf-8"?>
<configuration>
<appSettings>
<add key="mappedname" value="username"/>
<add key="mappedkey" value="password"/>
</appSettings>
<system.web>
<globalization fileEncoding="utf-8" requestEncoding="utf-8" responseEncoding="utf-8" />
</system.web>
</configuration>
And the application connection string is as follows:Dim usersql As String = System.Configuration.ConfigurationSettings.AppSettings("mappedname")
Dim passsql As String = System.Configuration.ConfigurationSettings.AppSettings("mappedkey")
connectionString = "data source=xxx.xxx.xxx.xxx;initial catalog=databasename;"
connectionString &= ";user id=" & usersql
connectionString &= ";password=" & passsql
I am obviously missing something. Not sure what or how to pass the permissions on properly.Can some kind soul please help me with this problemThank YouJeff
Remote Access
Oct 26, 2000How can I access Sql server via a remote access tools. I want to be able to use somekind of software to be able to work on a server as if I am physically there. I would appreicate your input about this issue.
Ali
Unable To Remote Access
Nov 22, 2006Hi all,
I encounter a problem of unable to access Remote Server after i placed my web application into the web server.
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 connection could be made because the target machine actively refused it.)
So I googled and tried lot of different ways of connecting.By piped name, IP, trying instance which that server don't even have one :X.I also tried typing in cmd > telnet localhost 1433It appeared that the telnet fail, i tried it on other machine, it works. So is it cause by denied of access through that port?I checked at the sql client network, it show 1433, i check the server too, it show 1433.I also checked if there's any firewall, it appear there is no firewall at all.The sql server i trying to connect is SQL 2000, it run by Windows Server 2003
Any advise or more information you needed to help me solve this problem?Thanks
Remote Database Access
May 14, 2007Hi can anybody know how to connect remote database with asp.net application? Actually my database is in different machine (in different server, different location) so i want to connect that server. Every time I'm getting the fallowing message
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.
Thank you,
Nagu
Enable SQL Remote Access
Jan 21, 2008Hi.,please help.,i get this error.,i made my web and deploy it in a different system which is winserver03, we have in the same network.how will i enable SQL remote access:
Server Error in '/' Application.
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) Description:
An unhandled exception occurred during the execution of the current web
request. Please review the stack trace for more information about the error and
where it originated in the code. Exception Details:
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)Source Error:
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException (0x80131904): 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)] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800131 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186 System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) +737554 System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +114 System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +421 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +173 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +133 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +30 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +494 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83 System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +1770 System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17 System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70 System.Web.UI.WebControls.GridView.DataBind() +4 System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82 System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69 System.Web.UI.Control.EnsureChildControls() +87 System.Web.UI.Control.PreRenderRecursiveInternal() +50 System.Web.UI.Control.PreRenderRecursiveInternal() +170 System.Web.UI.Control.PreRenderRecursiveInternal() +170 System.Web.UI.Control.PreRenderRecursiveInternal() +170 System.Web.UI.Control.PreRenderRecursiveInternal() +170 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2041
Version Information: Microsoft .NET Framework Version:2.0.50727.1433;
ASP.NET Version:2.0.50727.1433
Access Remote SQL SERVER ???
Feb 3, 2004Hi :)
Is there a way that i can use to connect to SQL SERVER of my WebService Provider ??
I mean how do i upload my database to the SQL SERVER of my WebService Provider ???
Thanks
Remote SQL Server Access
May 11, 2004I'm using SQL Server to store session state. The Sql Server is on the local network but not on the web server. I use impersonation and use account credentials for the ASPNET worker process:
<identity impersonate="true" userName="domainuser" password="pass"/>
I'm able to access all resources and execute all pages without any problem.
When an object is added to session state I recieve the following error:
"Cannot open database requested in login 'ASPState'. Login fails. Login failed for user 'domainusername. "
Here is my web.config entry for using sql server (with modified connection string of course):
<sessionState mode="SQLServer" cookieless="false" timeout="30" stateConnectionString="Data Source=xxx.xxx.x.xx,1433;Network Library=DBMSSOCN;Initial Catalog=ASPState;Integrated Security=SSPI" />
I've checked and given the user i'm impersonating the ability to do everything. I've granted access on all necessary files, added them to the DB and made the user a db_owner of the ASPState table. I can log in to a machine as the user, then access sql server using the windows authentication. I granted 'act as part of the operating system', 'access this computer from a network', 'log on as a service', 'log on as a batch job' on both the remote computer hosting sql server and the web server.
The strange thing is i installed the asp session state tables on my development machine, using the same configuration file to run everything, and was able to add an object to session state without any problem. But when i specify the remote server, i'm denied.
Anybody have an idea?
Cant Access To Remote MS SQL Server!!!
Sep 8, 2004Here is the connection string i used:
"Data Source=<IP>,1433;Network Library=DBMSSOCN;Initial Catalog=<dbname>;User ID=sa;Password=<pwd>;"
i use that to connect to the remote SQL server, which has status of port 1433 at "Stealth"... do i need to open the port complete, if yes how i do that ?
does the SQL Server must use SQL authentication ?
Your help is greatly appreciated.
Remote Server Access And RPC.
Apr 2, 1999I want to access the other server from my Enterprise Manager by using
<server_name>.<db_name>.<tab_name>.<procedure>/table_name.
Pls. let me know the steps I have to take I have added two remote logins in
both the server. I also gave trusted right by using sp_remoteoption procedure
and still I get the message 'the object <server_name> not accessible>
Please reply at the earliest, as I am right noe accessing the other servers data
by bcp-out and bcpin into this server.............
Remote Access To SQL Server 2k
Feb 25, 2002Hi,
I am trying to access SQL server remotely (over the internet). I would like to use query analyser as my front end tool. Can anyone point out the procedure to do the same. I have the IP address and the host string.
Thanks
Chetan
Remote Access MS SQL 2000
Apr 29, 2008Hello,
I have problem with my SQL server. When I want to connect from localhost, its OK. But, when i want to connect it from other computer, i will recive this message: Timeout expire. If I try connect in enterprise manager of client, i will receive SQL Server does not exist or access denied.
I have selected Mixed mode and I am not using firewall.
Some solution? please help. Thank you very much.
Remote Data Access
May 27, 2008Hi,
I have an MS SQL Server 2000 database running on a local area network. The database contains product info that I would like to use to populate a web catelog being hosted off site.
Can someone point me in the right direct regarding common practices for using this product database, which is updated on a regular basis, to update my Web catelog?
I was thinking periodically the Web server could remotely query my product database for new entries (this does not need to be real time).
What do you think...
Remote Access MS SQL Server
Mar 17, 2004My ISP provide MS SQL Server. I can create my database name, dbusername and dbpassword through control panel and then I can access the database in ASP using this connection string "Provider=SQLOLEDB;UID=dbusername; PWD=dbpasword".
Before, I could also use my enterprise manager to create a new sql server registration using my web url, dbusername and dbpassword. But now it seems that my ISP blocks the port or something and ask me do everything through the control panel.
Does anyone have some idea to connect to a remote server thorough enterprise manager based on the infromation I have?
It would be very helpful for your opinion!
MSAccess And MS SQL Remote Access
Mar 18, 2004I am having issues with MSAccess and MS SQL for a new client. It worked in the past, but I cannot talk to the old computer guy?!# Here's the scoop. It uses an Access front end and ODBC to conect to the MS SQL 7.0 server. In the office they use a system DSN named DATA to connect using NT authentication. I've got the firewall configured for the two employees static ip addresses to goto the MS SQL server. On the remote machines, I have added a system DNS named DATA as well that uses MS SQL authentication. I setup the remote user accounts on the MS SQL server. Now heres the problem. I can test the ODBC from the remote omputer and it works.At first I could not get into teh database at all. I went in and updated the Access file connection strings to include a username and password. Now I can get into the Access front end and access the main page. (IT has a couple of buttons - Shpping, Inventory, Management, etc.) I can even click on these buttons and pull up the next page. (For example I can click on the management button and pull up a list of new buttons- one of which is Auto Exec Bob) NOw when I click autoexec bob or any of the others it takes a while and then give me an error. (SQLState 28000 MS SQL error: 18452 Login failed for user null. Reason: Not associated with a trusted SQL Server Connection.) If I click ok then I have a box that lets me uncheck the use trusted connection and sign in using my remote username and pass that I setup. Eventually I can access everything - one step at a time.Each time it tries to connect to the database it takes about thirty seconds to time out, then gives me this error message and I can log on again. Any help to sort this out would be greatly appreciated. Thanks in advance.
View 1 Replies View RelatedSQL 2012 :: Remote Access To Set Value Zero
Feb 21, 2015Version SQL 2012.
Exec sp_configure remote access running values is "1" by default. If set the value "0", what will be impact on both server and client side?
1. Client side: remote access option value is "1", it mean to allows executing stored procedure in remote client side by using SSMS. server itself does working all SP which was passed by through application(remote application server even SQL port enabled between application DB and App servers).
Impact: value is "0" developer does not able execute SP their Client SSMS side after connecting established in DB server.
2. Server side
Impact: Does it working Linked server if value is "0?
Remote Access To SQL Server
Apr 3, 2008Does anyone know of a good place to find instructions on how to set up remote access to my SQL Server. I have been unsuccessful finding anything on this topic.
Thanks in adavance
SQL Express Remote Access
Oct 30, 2006Can a database on SQL Express 2005 server be accessed remotely in a network?
View 4 Replies View RelatedProblem With Remote SQL Access
Jan 8, 2007I installed sql 2005 (server) in two Win-Xp machines and tried to access each other, it was working fine, after that I tried to mirror the data base (I already installed SP2 in both machine) then I am getting an error saying,
"A connection was successfully established with the server, but then an error occured during the preloging handshake.(provider SSL,error:0 - The certificate chain was issued by an authority that is not trusted.)(microsoft SQl Server)"
After that I could not connect the the sql remot. If any body knows the slution pls reply me.
Thanks
Remote Access To Website
Feb 6, 2007I upgraded from msde to sql server express. Everything seems to work just fine. I can odbc to the database servver and can view website from local server but cannot access website from remote server. It gives me Cannot find server error.
Help is appreciated.
Is ASP The Only Way For SQL Remote Access Via Internet
Jul 20, 2005Hi.I would like to access my database outside of my company. I read manydocuments but they are all pertaining to accessing the database viaASP or some form of web application. Is there no single windows orlinux application tht runs natively to access a remote SQL data base?Any advise is appreciated. Thanks!!
View 5 Replies View RelatedVB Cant' Access My Remote Database
Feb 8, 2007Hi everybody
I have a remote SQLExpress instance running. I can connect to its databases with the SQL Server Management Studio Express and Visualstudio (Datasources) on a remote system and on a local system.
But as soon as I try to run or debug a vb application a system security error apears.
Thanks for you help
Ueli
Remote Access To Sql Server
Jan 24, 2007Hi,
I use a VS2005 application with a sql database. All is working well over a local network but I now want remote access to the system via the internet.
Is this possible? I have a fixed IP address & am wondering if I can just use the ip address as part of the connection string? (And if so - how!)
Remote Access : Where Am I Wrong ?
Oct 28, 2006Hi Gurus,
I new to SQL Server and unable to connect Reomote Connection.
The Environment:
Server (Name:SmartDB)= Windows XP SP2 with "Administrator" user
Running: SQL Server 2005 Express (Standard)
SQL Browser
SQL Server Configuration:Protocol=TCP/IP=> Enabled
Windows Firewall = OFF
Laptop (Name:PSDLaptop)(using as client machine)=Windows XP SP2
with "Administrator" user
Network Status: Working Fine
-------------------------------
When I am running an application with following CONNECTION STRING:
"Data Source=SmartDBSQLEXPRESS; Database=PSD;Integrated Security=SSPI"
the error comes:
"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.)"
AFTER IT WHEN I TRY TO ACCESS NETWORK FROM ANY MACHINE,
IT FAILS TO ACCESS WITH FOLLOWING MESSAGE:
"\<Machine> is not accessable
You might have permission to use the network resource.
Contact the administrator of this server to find out
if you have access permissions.
The network path was not found."
<Machine>=SmartDB/PSDLaptop
--------------------------------
I don't know where am I wrong.
Please tell me.
Thanks and regards
Remote SQL Server Access
Sep 7, 2007
I'm writing a piece of software that is designed to access data from SQL server. The office's server has SQL server version 7 installed. The software works perfectly when running on a computer on the network in the office. I however am trying to work out how to use use the software from my home computer and connect to the SQL server database remotely. I've never done this before and I'm finding it hard to find the right information.
Firstly, is it easy to do this? What do I need to do with the server in the office to allow this to work? Do I need any extra hardware/software? How will my software connect to SQL server? Is it as simple as changing the connection string to something like the server's ip address and sql server name?
I'm writing the software in Visual Studio 2005 professional and programming in VB.
Many thanks.
Setting Up Remote Access
Jul 21, 2006Hi,
I have written a VB program using an SQLExpress database on my machine, and I want other users to remotely access it. From what I have read, all I have to do for the Client machines is load on SQL Native Client and install the EXE. I have also enabled TCI/IP etc and setup the exceptions on my firewall. My connectionstring is
"Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;Database=<mydata>;Data Source=<machinename>sqlexpress"
When I run the EXE on the client machine, I get the following error...
Cannot open database <mydata> requested by the login. The login failed.
I am totally new to SQL and would appreciate any help in getting this setup. Do I need to put my login details into the connection string so other PCs can log into my database..?
ACCESS was never this hard to deploy, but I really want to learn SQL.
Thanks in advance
Security - Remote Access
May 4, 2007I'm creating an app that will connect to a central sql server 2005 (hosted on a Win2003 server with Windows Firewall on). I added sqlservr.exe and sqlbrowser.exe to the firewall exceptions to allow for remote connections. Now, an admin I know is telling me that this is not secure and we must configure those 2 exe's to only be accessed by certain IP addresses. I want to make sure the database is very secure, but this sounds like overkill. ??
Questions:
Is this necessary (to limit access to these 2 exe's to certain IP addresses)?
How would I be able to distribute my application to different users if this is so?
How can I make sure that the SQL Server won't get "attacked" or "hacked"?
Mel
Access Permissions====urgent
Aug 3, 2000Hi,
I am having 10 tables in my database. Some times users are complianing that they are not getting permission to one particular table. I checked the table and the owner is dbo only. Why it is behaving like this. the users having all permissions on the database. Pls suggest me.
--thank u
--Rk
Urgent ...MS Access Problem....
Nov 30, 2005Hello Experts,
Pl. help me in designing a small application..This app. is to be used by 12 users. We need
an application to log time spent by the team in office.so this is a time sheet system. I
know how to design a table, a form etc..My question is how can many users share the same
database?
Let us say that on my computer I have created the database as db1.mdb. (it has all the
tables , forms etc) Now for other users to use this what do I have to do?
Also can MS Access be used to make an application which supports simultaneous use by 12
persons?I mean can it support such an app?
Will be most thankful for your inputs..This is urgent.
N.
URGENT - Why Can't I Link To Access?
Mar 29, 2006Hello,
I think I may be going a little bit mad. Last week I created a database on SQL Server. I then created an access database on a different windows server, and set up an ODBC connection on that windows server to my database on SQL Server. I then set up linked tables within Access to point to my tables on the SQL Server. I'm fairly sure that I opened those links at the time and managed to display and update the data from Access. However I have come to this today and when I go into the Access database and attempt to open one of the links I get a connection failed message. When I check the ODBC connection on the windows server it is fine. Does anyone have any ideas on this? I really need this to be working by tomorrow to do a demo, and I'm so convinced it worked last week I am a little bemused!
Many many thanks in advance of your wonderful and prompt replies!!! :)
Paula