Ok. Here is what I need to do: several computers on the intranet need to use a client program to access data from the server (a desktop)
Here is what is going on:
1. I am using Visual Studio 2005 c#.net 2.0
2. Sql Server Express 2005
3. I don't have IIS set up
4. The database is being shared from the c drive on the server (not sophisticated at all, but this is a one man operation!)
Questions:
1. Is IIS an absolute must to make this happen?
2. If not, a user pointed out that I can't use UNF to access the database. How do I set up the connection string to access the db on the server?
Hi there! I've been trying for several days now to configure SQL Server 2005 to allow remote connections, apparently, with no luck. I always have this error message: Microsoft SQL Native Client: 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. I've followed the instructions at this link -> http://support.microsoft.com/?kbid=914277&SD=tech, but I have been having the same problems. I've already adjusted my firewall settings. What should I do? Please help me...
Hello there, I just deployed a new ASP.NET 2.0 website on a remote server http://www.alrazem.com/. and when i want to log on, or when any connection to the database happens!! the following error ocurs.
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)Anyways, I searched the new. and i found this link: http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277... I followed the instructions and changed the Surface Area Configuration for Services and Connections to Local and remote connections. and Applied both protocols. Then redeployed the application. but the error still ocurs. I didn't restart my machine after changing the SQL to remote. but i did the website from scratch again. and created a new connectionstring and database!!! Any help? Thanks!
Hello. I have SQLEXPRESS 2005 installed on my laptop running Windows XP Home Edition with SP2. I have an application that can connect to the local instance with no problem. The other day, I tried to configure SQLEXPRESS 2005 for a remote connection from my desktop. To date, I have been unable to figure out how to do this.
I have followed the instructions posted at various locations on the internet, but to no avail. While I can configure SQLEXPRESS 2005 to allow TCP/IP connections, I have been unable to restart the server.
Here is the pertinent snippet from the error log:
<time> Server A self-generated certificate was successfully loaded for encryption. <time> Server Error: 26024, Severity: 16, State: 1. 2006-08-14 21:02:27.18 Server Server failed to listen on 'any' <ipv4> 0. Error: 0x277a. To proceed, notify your system administrator. <time> Server Error: 17182, Severity: 16, State: 1. <time> Server TDSSNIClient initialization failed with error 0x277a, status code 0xa. <time> Server Error: 17182, Severity: 16, State: 1. <time> Server TDSSNIClient initialization failed with error 0x277a, status code 0x1. <time> Server Error: 17826, Severity: 18, State: 3. <time> Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log. <time> Server Error: 17120, Severity: 16, State: 1. <time> Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.
I have a feeling this problem is due to the way my system is configured, not necessarily how my SQLEXPRESS 2005 is configured. My laptop and desktop are connected via a wireless router, and both machines are running Norton Anti-Virus 2006. I've added sqlserver.exe and sqlbrowser.exe to the exceptions list for the Worm protection on the laptop, i.e., the server machine. There's not a setting at the router that would prevent the server from re-starting, is there?
As you know SQL Express by deefault accepts only local connections
For a particular requirement i have to change SQL Server Surface Area Configuration to accept remote connections by dos command Anyone know this command? thanks Marco
could anyone guide me on how to allow, ceate rule for sql server 2005 remote connections to work. i already configured my sql server to allow remote connections and also my router, it is only in isa that is blocking the connections.
I already asked this question at the MSDN forums, but I'm asking it here because I got conflicting answers.
I want to configure my server to allow remote connections. For some unknown reason, I'm unable to do this with the Surface Configuration Tool. My understanding is that I can accomplish this using the sp_configure stored procedure. Is this correct? If so, can someone please give me an example of the correct syntax? BTW, I'm running SQL Server 2005 on winxp pro sp2.
Sorry for the newbie question, but.... I have developed a website on my local development machine. When I create the connections string VS automatically creates a path to my local hard drive inside the string. Data Source=.SQLEXPRESS;AttachDbFilename="C:Documents and SettingsMikeMy DocumentsVisual Studio 2005WebSitesPostAlertzApp_DataPADatabase.mdf";Integrated Security=True;Connect Timeout=30;User Instance=True However, when I deploy this website to a remote server, SQLExpress tries to attach to the file using the wrong path. How do I fix this? Your patience is appreciated...
I use MSSQL Server to store the configure info and create deploymentutility to deploy the package on remote server, If the configure info could be created automatically while deploying? or I have to create the Table on remote server to record the configure info in manully? Thanks a lot
Vista + SQL Server 2005 Reporting Service Configuration Tool: No Red Cross. http://localhost/reportserver get this error: HTTP Error 403.1 - Forbidden You have attempted to run a CGI, ISAPI, or other executable program from a directory that does not allow executables to run. http://localhost/reports get this error: w3wp!ui!4!20/02/2008-17:17:04:: e ERROR: Unable to connect to the remote server w3wp!ui!4!20/02/2008-17:17:04:: e ERROR: HTTP status code --> 500 -------Details-------- System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 127.0.0.1:443 at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress) at System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP) at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Int32 timeout, Exception& exception) --- End of inner exception stack trace --- at System.Net.HttpWebRequest.GetRequestStream() at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Microsoft.SqlServer.ReportingServices2005.ReportingService2005.ListSecureMethods() at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods() at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods() at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname) at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection() at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level) at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at System.Web.UI.Page.OnInit(EventArgs e) at System.Web.UI.Control.InitRecursive(Control namingContainer) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) w3wp!ui!4!20/02/2008-17:17:06:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.End() at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm) at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.End() at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm) at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
I googled but not found anything useful. Thanks in advance!!!
Hi All, I am new to SQL server 2005. I have installed SQL server 2005 which came along with the visual studio 2005 package. Now i could see the visual studio 2005 in the installed programs list. I really dont know how to configure the the installed SQL server. how to create tables and veiw. frankly speaking i could not see where is the head and tail.
To be straight forward, i havent used any database to a great extent. earlier during the starting of my career, i developed a small application using VC++, which used to interact with the DB server on a very minor scale; whenever i wanted to create a table for used to do it with sql client which was also installed in my machine.
currently i am againg devoloping a small apliccation using VC++, this time for devlopment and testing purposes, I have SQL server 2005 installed in the same machine which i am using for development. Now as i said eralier i am not even aware how to configure, how to start creating table...... :-(
all i have done is i have installed SQL server 2005 and all i could see is SQL Server 2005 listed in the installed programs list :-( some one please help me.... :-(
Login failed for user ''. The user is not associated with a trusted SQL Server Connection.
Ive got this error... I have just installed the SQL Server 2005 Standard Edition. Could anyone encounter and solve this problem.. please til me how to solve this. I google this but couldnt find a reliable solution for this..
Thanx...!
------------------- Real Programmer dont document
If its hard to write Then its easy to undertand. End If
With Linked server you can access DB2 resources as if it is another object in your SQL Server.
You don€™t have to establish links from all nodes to the DB2 Server.
Connection from SQL server 2005 to DB2 Server is sufficient to all SQL server users to access DB2 resources.
1. Install MicroSoft OLE DB provider For DB2 in SQL server 2005.
2. configure as follows: Start - - -> all programs - - - > MicroSoft OLE DB provider For DB2 - - - > Data Access Tool. Right click on data sources - - -> New Data Source In Data Source Wizard - - > Data Source plat form = DB2/MVS or any other appropriate plat form from drop down Net work type = TCP/IP - - > Next Address = IP address:xx.xx.xx.xx
Port Number: xxxxxxx - - -> Next Initial Catelogue = SAMPLE Package Collection = DB2INST1 Default schema = DB2INST1 Default Qualifier = Leave it blank - - -> NEXT HOST CCSID = EBCDIC- U.S./Canada[37] or appropriate one P.C Code Page = ANSI-Latin I[1252] or appropriate one Process Binary as character = check the box - - -> NEXT Interactive sign on - - - > select it Provide login name and password. Check "Allow Password saving" - - - -> NEXT Check appropriate boxes like read only etc. - - -> NEXT Click Connect tab - - -> make sure "Success ful" message is appearing Example: - "Successfully connected to data source 'DB2-server'. Server class: DB2 Server version: 8021.00.0000" - - - -> NEXT Provide a data source name.(Example: DB2-Server) Check initialization string option - - - > NEXT Review completed task list on the window and Select "FINISH" to complete the work. The data source which you have added just now(DB2-Server) will be appearing on the grid now. right click on the data source name and make a note of the path where it has formed right click on the data source name and click "Display connection string" cut and paste this connection string on the lower window to note pad for future use.
Start MS SQL server Management studio Add a fresh linked server in 'SQL Server - - > Server Objects - - -> Linked Server" as follows: Click Mouse right button on linked server and select "New Linked Server" linked server = Provide a meaning ful, fully identifiable name for Linked server(Example"DB2-Linux") Provider = MicroSoft OLE DB provider For DB2 Product name = DB2OLEDB Data source = IP address
Provider string = Paste the connection string pasted to note pad earlier. Location = Leave it blank Catalog = SAMPLE Click on security on the left side pane Provide an SQL Server login from the drop down Do not select check impersonate Provide DB2 username and password and remote user name and password. Click OK to save. You will find the name of liked server appearing below the object Linked Server(Example "DB2-LINUX")
Open a new query window and execute an open query Example: SELECT * FROM OPENQUERY("DB2-LINUX", 'SELECT * FROM SAMPLE.DB2INST1.EMPLOYEE')
In the Example "DB2-LINUX" is the name of the linked server "SAMPLE.DB2INST1.EMPLOYEE" is the name of the table. Sample = name of the db DB2INST1= name of schema to which the table belongs to Employee = name of the table
Another Example would be SELECT empno,FIRSTNME FROM OPENQUERY("DB2-LINUX", 'SELECT * FROM SAMPLE.DB2INST1.EMPLOYEE')
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
An error occurred during the execution of xp_cmdshell. A call to 'CreateProcess' failed with error code: '5'. Invalid destination path C:Program FilesMicrosoft SQL ServerMSSQLData. Changed database context to 'master'. (Microsoft SQL Server, Error: 15121)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=15121&LinkId=20476
Hi, I have a Windows 2008 server 64-bit SP1 and I have installed SQL 2005 SP2 Enterprise Edition 64-bit. My current version is 9.00.3042.00. I am trying to configure Reporting Services and I am having lots of trouble getting the Application Pools to work properly. I have followed the Microsoft Technet paper 839480 "How to Install and Configure Reporting Services on Windows Server 2008". In the "Configure Reporting Services" part, I have successfully configured everything (all arrows are green) and have the following setup:
Report Server Virtual dir: ReportServer Default Web Site Report Manager Virtual dir: Reports Defualt Web Site Windows Service Identity: ReportServer with a service acct login Web Service Identity: Report Server: ReportServer, Report Manager: DefaultAppPool (I get an error when I try to configure it to anything else: ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 800708AC at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool)
The one thing I notice in the SQL Server configuration manager is that there is a red dot next to the SQL Reporting Services services even though the green arrow is there to show it is running.
When I look in IIS7, I see the application pools Reports and ReportServer and they are both in Integrated mode. When I try to go to http://localhost/reportserver, it gives an error. It will work if I change both application pools to classic. But then when I try to go to http://localhost/reports, I get an error:
"REQUEST IS NOT AVAILABLE IN THIS CONTEXT".
I have read up on IIS7 and it says that: "This error is due to a design change in the IIS7 Integrated pipeline that makes the request context unavailable in Application_Start event. When using the Classic mode (the only mode when running on previous versions of IIS), the request context used to be available, even though the Application_Start event has always been intended as a global and request-agnostic event in the application lifetime."
So, how do I configure these application pools to work using IIS7 with SQL 2005 Reporting Services on a Windows 2008 server? I have tried all kinds of different things based on what I am reading on the net and nothing is working. Anybody have any suggestions?
I am attempting to insert information from Visual Web Developer 2005 using either the Gridview or Datalist controls into a SQL Server 2005 database and get stuck when defining the custom statement.When I enter the text within the insert tab, the <next> button remains greyed out, preventing me from continuing to the next page.If I copy the same text into the select tab, then I can continue with the wizard, however this raises other problems which may or may not be related (multiple insertions of the data into the SQL Server database table - possibly due to postback functions). I would rather use insert to confirm that my second problem is not because I am using the wrong option.My question is:Should I be able to use the insert function within VWD express or is this only available within the standard/pro editions?
I am trying to configure distributed transaction and XA support using Microsoft SQL Server 2005 JDBC Driver. I have coppied SQLJDBC_XA.dll from XA directory and placed in my sql server binn directory and trying to run the script xa_install.sql from binn directory with command as below :
But I am getting error saying : [DBNETLIB]SQL Server does not exist or access denied. [DBNETLIB]ConnectionOpen (Connect()).
when I replaced local host with the machine name it gives error : [Shared Memory]SQL Server does not exist or access denied. [Shared Memory]ConnectionOpen (Connect()).
where in I am able to test connection from Websphere using the same connection.
Please help some one ....... I am in URGENT need.... I need to enable XA suport for my application to run........
I have SQl Server 2005 installed in local computer. I am planning to create report by Report Service so a report server is needed by which I can deploy report from my local computer to that server. How to intall the report server in another computer/
Can anyone help me with a problem I have with SSRS 2005? How do I configure SQL Server 2005 Reporting Services to deliver subscription e-mails to addresses external to my windows domain?
I've been having trouble configuring the Report Server e-mail delivery component to send subscription e-mails to addresses outside the domain on which the report server is hosted.
For e.g. since my local windows domain is named "smartsystems.com", I have found that the Report Manager does not have any problems sending subscription mails to "eawagu@smartsystems.com" but throws up an error whenever I include "eawagu@yahoo.com" in the recipients' list.
For the first time, I want to set up the configuration of my SQL Server Management Studio Express (SSMSE) to allow me in doing the non-User-Instance/ADO.NET 2.0 programming from my VB 2005 Express. The SSMSE and VB 2005 Express are in my Windows XP Pro PC that is part of our NT 4 LAN System in our office. I read the article "How to configure SQL Server 2005 to allow remotre connections" in http://support.microsoft.com/kb/914277/ about (i) "Enable remote connections for SQL Server 2005 Express", (ii) Enable the SQL Server Browser service", (iii) Create exception in Windows Firewall, and (iv) Create an exception for the SQL Server Browser service in Windows Firewall. I entered the SQL Server Surface Area Configuration and I could not decide what options I should take for doing the non-User-Instance/ADO.NET 2.0 programming from my VB 2005 Express. I have the following questions on the page of "Minimize SQL Server 2005 Surface Area": (1) I saw "Configure Surface Area for localhost [change computer]". I clicked on [change computer] and I saw the following: Select Computer The Surface Area Configuration of this surface area of this computer or a remote computer. Specify a computer to configure: O Local computer O Remote computer Should I choose the "Local computer" or the "Remote computer" option? (2) Below the "Configure Surface Area for localhost [change computer]", I clicked on "Surface Area Configuration for Service and Connections", Select a component and then configure its services and connections: |-| SQLEXPRESS |-| Database Engine Service I picked => Remote Connection On the right-hand side, there are: O Local connections only O Local and remorte connections O Using TCP/IP O Using named pipes only O Using both TCP/IP and named pipes Should I choose O Local and remorte connections and O Using named pipes only?
Please help and tell me what options I should choose in (1) and (2).
Hello dear i am using windows 2003 server where i have installed smtp server now i want to configure with remote stmp so i can send an email to any domain.
Fellow Devs, I have an instance of SQL Server Express 2005 running on another box and I have Remote Connections enabled over both TCP/IP and Named Pipes, but on my other box I keep getting the error that the server does not accept Remote Connections. Any ideas why this might be happening? Is there some other configuration?
My site works fine in VWD2008 express, but I get this error when I try to use it on my live website. 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. According to this article: http://support.microsoft.com/kb/914277 I am supposed to:
1. Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration. Ok, there is no such program in this folder. The only thing in there is "SQL Server Error and Usage Reporting"... The other thing I am greatly concerned with is this: All is want is for my webpages to be able to access my database for user authentication. I DO NOT want to grant the internet rights to remote connect to my database.
i have trackit!6.5 application which works as follow: when installing it and if there is no sql server is installed then he install sql desktop and the application works fine now i want to use sql server 2005 instaed so i keep getting that error login failed for user trackit65 also i added myself so any idea ?? which schema or member ship shall i use also i got error event id 18456 with no ERROR STATE listed with it
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 :(....
I have SQL Server 2005 express loaded on my webserver and I have loaded SQL server studio manager on another terminal. When I try to connect to the SQL Server it tells me that i can't and because the SQL server does not allow remote connections. How do I fix that?
got the following error in my site. am using visual studio 2005 vb.net sql server 2005. my webhost (philhost.net) said that they support mssql server 2005. please help 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:
Line 16: Dim myConnection As New SqlConnection(strConnString)Line 17: Line 18: myConnection.Open()Line 19: Line 20: Dim myTrans=myConnection.BeginTransaction()Source File: E:inetpubvhosts\httpdocsDefault.aspx.vb Line: 18 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) +739123 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) +685966 System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +109 System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +383 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) +170 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +130 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 _Default.Button1_Click(Object sender, EventArgs e) in E:inetpubvhostshttpdocsDefault.aspx.vb:18 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105 System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +174 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102
Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832
My problem relates to backing up my MS SQL 2005 database which is sitting on a shared server at a hosting company.
OVERVIEW: - Hosting company is using MS SQL 2005 - I am using the SQL Server Management Studio that comes with SQL Server 2005 Standard (NOT Express), which is installed on MY PC. - So, I am connecting to the SQL server over the internet
WHAT I WANT TO ACHIEVE: - I would like to backup the data sitting on the Hosting company's MS SQL Server. I only have one database on this SQL Server. There are of course 100s of other databases on the same server which belong to other customers of the hosting company.
- I want to bring the backup to MY PC, from the SQL Server.
- As far as I can tell the following options within SQL Server Management Studio may be of help to me. I do not know which one I should use or which one is best or what is the proper method. 1) Select Backup option from the Tasks menu (but it only shows me drives/devices on the Hosting SQL Server, not my PC, so I can’t backup to my PC) 2) Export Data (it does not work, showing errors ‘…not a trusted connection…’ I have no clue what a trusted connection is. 3) Copy Database (which is supposed to copy the remote database on the Hosting company SQL server, to my local SQL Server running on my PC). I go through the wizard, on the last screen it just hangs i.e. shows- not responding)
MY QUESTION TO THE COMMUNITY: How do I backup the database sitting on the hosting company SQL server? I of course need to bring the backup to my PC.
Snehalata writes "i have one database at sql server 2000 and i have one database at sql server 2005. now i have added linked server to sql server 2005. i wish to access database located at sql server 2000 from sql server 2005 by creating a view in database located at sql server 2005. but when i access database located at sql server 2000 from sql server 2005 i get error message
OLE DB provider "SQLNCLI" for linked server "OLDPARTNER" returned message "Login timeout expired". OLE DB provider "SQLNCLI" for linked server "OLDPARTNER" returned 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.".
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 am new to SQL Server and need to understand how to run DTS packages (SSIS) in SQL 2005 from a remote server? In other words run them from another server from where the database is installed.
I am looking for any links on the subject, guidance on how to set this up and how to use it.
I have set up a SQL Server 2005 to use for testing before moving to another production server. The server works fine when I connect to it with a program on the same computer but not when accessed remotely.
I have set it to to allow remote connections and use TCP IP only and have opened TCP port 1433 on the Windows XP firewall and am using the Teredo service on Port UDP 3544 Also the Server Browser service is running. The server is connected directly to the internet on a static IP (eg. 67.156.18.167) I have set the server to Windows authentication.
When I try to connect to the database from a data grid in Visual Studio on another computer it fails.
I am pretty surethat the problem is that I am not giving the correct information when asked to fill in the information for the data source to find the server as I am new to remote connections in SQL Server.
I have an application developed by VB.NET 2005, and I need to install the Data base on a server to allow the clients access the data base from thier own computers, i need to allow all the functions on that data base (Insert, Update, and Delete).
I tried to do it by installing the SQL Server on a computer named (PC1) and the application on a computer named (PC2), and they are connected to the same subnet, I need to know what are the properties that I should do on the SQL Server in order to be visible through PC1 to make the connection string? And does the authintication mode affect the process?? whether it is Windows authintication or SQL Server Authintication??
Note: I am using SQL Server 2005 Developer Edition.
