- 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?
I just want to find out what the difference between a remote login and a remote query is. I'd have thought that a remote query inherently requires a remote login.
View 6 Replies View RelatedHey All,
Very simple one...how do I simply change the default from 20 seconds to 60 in the sp_config table...
Thanks,
DJ
How to configure SQL Server to connect remote database.Thanks!
View 5 Replies View RelatedHi,
We are creating a small apllication ,and we want to deploy all the reports in the single server ,how to configure this server,
so that others can acces the reports in this server and also deploy their reports
A SQL server 7 database I have been developing has recently been moved outside a firewall (for various reasons). I have found that I cannot access query analyser or enterprise manager via an IP address. Is their any way around this?
View 2 Replies View RelatedHi :)
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
I'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?
Here 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.
I 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.............
Hi,
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
My 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!
Does 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
Hi,
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!)
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.
I am trying to read the databases attached to the Sql Server 2005.... my code works fine for Sql Server 2000 but when i try it with Sql Server 2005 it gives me error that "Under Current Settings SQL Server 2005 does not allow remote connections".
Can anybody tell me where to change these settings... i tried my best to find it but :(....
What does this mean and how do I change it and what problems could this cause?
View 3 Replies View RelatedHello SQL guys,
If possible to connect our remote server from my end ?.what r the possiblities is there.tell me some ideas,i already tried it to register our remote server database thru ODBC but it not connected properly but i ve tried in our intranet/network it's working fine.
Nellai
I was just trying out Microsoft SQL Server 2000. I created a sample application which reads in 2 values from a textbox and writes it into a databse. This application works fine on my computer and the values are written to the database (In the connection string, I give my IP address as the datasource so that anyone on the internet can hit this database). However, when I copy this application to another computer and try to run it, it gives me an error "SQL Server does not exist or access is denied." I know this is a minor problem with some setting, but I haven't been able to find the solution on the internet. Can someone whose worked with Microsoft SQL Server 2000 please help me out.
View 9 Replies View RelatedI have a website which runs off a Access database which I am currentlyconverting to sql server database. I would like to still use my accessfront end for reporting and queries..I created an odbc connection on my computer to the remote sql serverand created a link in access to my sql server tables. All my report andQueries run fine I just have one problem it keeps on prompting me forther password of the remote sqlserver database. I check the odbcconnection and I see the password is not saved in there even though Iput it in. Is there a way I can have the password saved. I do not wantkeep on having to enter the password.
View 4 Replies View Related
Hi all,
i need to upload time tracker in a static ip which doesnt have sql server, after the installation there in static ip, i receive the following error while trying to access
Named Pipes Provider, error: 40 - Could not open a connection to SQL Remote Server 2005
need help???
Regards,
Prasenna. K
if i can somehow load/copy a sql directory with mdf etc on pcs shipped to our customers with our app, but sql isnt installed/running on the shipped pc, can our customers' sql instances running on their existing machines "see/use" our shipped database, assuming the hard drive on the shipped pc can be made to look like a mapped/remote drive? We wonder about 2000 and 2005.
View 3 Replies View Related
In order to fix a web application bug the developer told me to to edit a stored procedure on my hosted SQL 2005 server. The hosting company's support say I should be able to do this using SQL Server Management Studio Express. I installed SSMSE, but it seems to want to only want to connect to a local server. Can I use this utility for remote DB management, or is there something else I need instead?
Thanks for your help.
-Michael
Sorry if this has probably been answered before, but...
I have a sql server 2005 behind SonicWall (not familiar with this firewall).
How do I access this server over the internet? how do I grant access to it?
I have an available IP address, where should I put it?
What steps do I need to follow? I am new to all of this.
I have set the server to allow remote connections
I have selected TCP/IP as the preferred mode of connection.
Thanks in advanced.
Hello,
i have two server connected to internet S1 and S2 (connection between both is only internet too).
I need write trigger on S1 which send update or another command to S2. Is it possible, and how (without using .NET methods only by using Transact SQL)?
Thnx, jakub.
Please excuse me as although I have lots of database design & development experience I'm not database administrator and I'm new to SQL Server.
I have a SQL server 7 database on a remote web server which I can access over the Internet.
I have SQL server 7 installed on my local network server and I use Enterprise Manager to administer and configure the databases on the server.
Can I use Enterprise Manager to administer and configure the remote database?
If I can't then how do I make changes to the remote database? Do I need to FTP objects or use RAS?
Any help would be very much appreciated?
where can check for SQL Server service account write access permissions ??????
and if it don't has permission How can i set the write access permissin.
Thanks & Best Regards
Madhu
I am currently using a Microsoft Access (MDB) for my application. But I am looking at allowing other users on the network access the same database -- I know a Microsoft Access database is not the best solutuon for this enviroment.
I'd like to use SQL Server 2005 Express in this case. I am very fimilular with SQL Server 2000 Std/Ent editions. My question is, can I use the free SQL Server 2005 Express edition and allow remote users to connect to that database? Or is it supposed to only be used as a local database accessed by only the machine it's installed on?
Thanks,
Jason
When i connect the SQL server Remote Connection Through LAN that time it working fine but i switch over to wifi connection that time it is not working, and also the system not find SQL server Instance Name..
View 3 Replies View RelatedHi,
I am a VB6 programmer and I'm really new to SQL Express, I have always used ACCESS because it was so easy to deploy. I've now written a VB6 program which uses SQL Express and I want to know how to deploy it. Basically my PC will host the SQL database as it has SQL Express loaded onto it. I now want to install my EXE onto other Client's PC and have them read/write to the database on my machine.
Besides the EXE program, what software do I need to load onto the Client's PC so they can access my SQLExpress database...? (eg: Net Framework, SQLExpress, etc).
Also, if my machine is called ABC123, in my connectionstring do I just put in
ABC123sqlexpress as the datasource..?. Will this be enough for the other PCs to connect to mine ?
Thanks
Hi guys
I'm writing a C# application which connects to a local SQL database for data access. The application connects to SQL Server through windows authentication, but opens up the port and sqlbrowser to others on the network wanting to access the database through SQL Server authentication, and also allows remote users to connect to this server remotely if they have the login and password (and because the port is already open)
I understand this is not secure and open to attack, and am unsure of how to secure these processes without blocking these three types of access, from A.) the local user, B.) the network user and C.) the remote user across the net.
Have researched this a fair bit, but get somewhat lost amongst all the jargon.
I am making a WPF app, and I want to use SQL Server Compact 4.0 for database management, but it doesn't support Remote data access, on the other hand SQL Server Compact 3.5 does support it but I can't use it in WPF ( I've installed it but can't add it in my project, it's not there in the templates). So is there any alternatives, for a light DBMS, that are not installed separately?
View 3 Replies View Relatedhey guys i am getting this error on my link server it is sqlsqever to sqlserver link
error 7416 access to remote server is denied because no loggin mappings exists