Remotely Configuration Help??
Mar 24, 2003
Hi,
It might be a silly question but really took my head. I have a http server and wanted to install SQL server there, so that my client in US can access it. I just wanna know is there anything specific settings while or after installation I need to do so that they can access it and can configure in their Enterprise Manager.
Is it okay if I simply install SQL SErver 2000 in my http server and give the IP address of the server with the port number so that they can go to Client Network Utility and add my server. Later they can come to Enterprise Manager and connect to that?
Please advice me how it is to be done.
Thanks in advance
Rahul
View 2 Replies
ADVERTISEMENT
Sep 22, 2007
I am getting following error when trying to install SQL express 2005 on XPSP2.
TITLE: Microsoft SQL Server 2005 Setup
------------------------------
The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine SIGMA-805539A79 Error:2147944122 (0x800706ba).
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=70342
I tied re-installing WMI using http://blogs.msdn.com/jpapiez/archive/2004/12/09/279041.aspx link but could not get it working.
Do i need IIS installed? Its not installed on this box...
please suggest something... i am stuck...
Thanks,
View 3 Replies
View Related
May 2, 2007
I have just finished installing SQL 2005 Ent Edition on Win 2000 Adv Server, SQL2005 SP2, and SP2 Hotfix KB934458. After the installation, I could see and configure all services via SQL Configuration Manager and SQL Server Surface Area Configuration tools. This worked for a couple of days and now both configuration tools no longer detect SQL2005 components. SQL Server Surface Area Configuration issued an error that said "No SQL Server 2005 components were found on specified computer. Either no components are installed, or you are not an administrator on this computer. (SQLAC)". SQL Configuration Manager did not list any installed services. I don€™t know what caused this. Anyone has any idea? Please help! Below is the Installation Report which shows installed components.
===================================
The following components are installed on this server
DEV
Analysis Services
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
Database Engine
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
Reporting Services
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
QA
Analysis Services
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
Database Engine
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
Common components
Integration Services
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
Notification Services
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
Workstation Components
[Version: 9.2.3042.00 Edition: Enterprise Edition Patch level: 9.2.3054 Language: English (United States)]
===================================
View 1 Replies
View Related
May 23, 2006
Hi --I was wondering if this is a bug when I add new data in my table SSIS Confiurations and give wizard a new Configuration filter the package configuration wizard can not see the new values --the old values from the previous configuration are still showing---is there any known workaround or forced refresh I can do
thanks in advance Dave
Background:
SQL Package Configurations are most important because they provide the possibility of a central configuration store for your entire enterprise!!!!!!!! and is in my mind the only way to go
http://sqljunkies.com/WebLog/knight_reign/archive/2005/01/24/6843.aspx
Wizard results:
Name:
ETL
Type:
SQL Server
Connection name:
ETLConfiguration
Any existing configuration information for selected configuration filter will be overwritten with new configuration settings.
Configuration table name:
[dbo].[SSIS Configurations]
Configuration filter:
PT_CUST_ABR
Target Property:
Package.Variables[User::gsPreLoad].Properties[Value]
Package.Variables[User::gsPostLoad].Properties[Value]
Package.Variables[User::gsLoad].Properties[Value]
Package.Variables[User::gsFlatFilename].Properties[Value]
Package.Variables[User::gsFileName].Properties[Value]
Package.Variables[User::gsCDOMailTo].Properties[Value]
Package.Variables[User::gsCDOMailSubject].Properties[Value]
Package.Variables[User::giRecordCount].Properties[Value]
Package.Variables[User::giFileSize].Properties[Value]
Package.Variables[User::giBatchID].Properties[Value]
Package.Variables[User::gdFileDateCreated].Properties[Value]
Package.Connections[MyDatabase].Properties[ServerName]
Package.Connections[MyDatabase].Properties[InitialCatalog]
USE [ETLConfiguration]
GO
/****** Object: Table [dbo].[SSIS Configurations] Script Date: 05/23/2006 13:34:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SSIS Configurations](
[ConfigurationFilter] [nvarchar](255) COLLATE Latin1_General_CI_AS NOT NULL,
[ConfiguredValue] [nvarchar](255) COLLATE Latin1_General_CI_AS NULL,
[PackagePath] [nvarchar](255) COLLATE Latin1_General_CI_AS NOT NULL,
[ConfiguredValueType] [nvarchar](20) COLLATE Latin1_General_CI_AS NOT NULL
) ON [PRIMARY]
View 3 Replies
View Related
Jan 14, 2006
It seems to me, that the best way is to have one Environment Varible containing the name of the SQL Server, so that you can look up the configuration in the SSIS Configuration Table when you run the package.
Is this the preferable way of doing it ? I would like to hear some positive/negative comment of why chosing a configuration type instead of another.
It seems to me that putting all of the configuration in the Environment variable is harder work but most secure (server breakdown vs table corruption/database error...)
Let's have some comments
View 3 Replies
View Related
Jan 7, 2008
Sub Page_Load(sender As Object, e As EventArgs) 'declarations Dim conLath As SqlConnection Dim cmdLath As SqlCommand Dim rdrLath As SqlDataReader conLath = New SqlConnection("server=SERVERNAME;uid=USERNAME;pwd=PASSWORD; " & "database=DATABASE NAME") conLath.Open cmdLath = New SqlCommand ( "select * from Emails",conLath) rdrLath = cmdLath.ExecuteReader() gridLath.DataSource = rdrLath gridLath.DataBind() rdrLath.Close cmdLath.Dispose() conLath.Close End Sub
Can i connect to SQL on another server ? Becasue when i am trying to do so , i getting error ! I can connect to sql on my server but if i want to connect to another server i getting error ... help pleas ?
View 1 Replies
View Related
Sep 27, 2004
Has anyone experienced any limitaions or concerns for managing SQL 2K remotely using remote desktop, pleased advise.
Thanks
View 1 Replies
View Related
Jun 27, 2007
If I let the pages (ASP) running on the third party server access my database (MS SQL) remotely, what should I do with my database server? I was told to open a port. If it is true, what is the number of the port I should open?
Thanks in advance
View 2 Replies
View Related
Mar 7, 2008
Hi all SQL experts,
I am scheduling a job which need to run a store procedure on the other server. How can I do that?
Thanks a lot.
View 1 Replies
View Related
Jun 8, 2007
If I have SQL 2005 Standard installed on a server and I log on locally to that server. Can I connect to other machines through Management Studio-->Object Explorer that have SQLCE installed and manage the CE DB?
I think you can only connect to either local .sdf files or ones located on a device attached by USB to the local machine, but I have had some difficulty finding a definitive statement on that.
Thanks
View 1 Replies
View Related
Jul 11, 2006
Can you use SQL Express remotely instead of locally.
I have been told that I might be able to use SQL Express as my network server for sharing files. Is this possible, or do I need a different version of SQL to do this?
I have been reading the VBE forums and from what I gathered was that SQL Express is only for a local table only, is this true?
If not, what is the work around, and how do I go to another pc to find out if it is sharable?
I would hate to get several months in my app design and learn that I was headed in the wrong direction.
Thanks
David
View 8 Replies
View Related
Jun 26, 2007
I've combed through SQL Help to find the answer to my question but I think it's telling me it can't be done. I work both from an office with my servers and from home. When I'm at home I would like to access my SQL server remotely using a tool such as MS SQL Server Management Studio. But it appears there is no way to access my SQL Server for management purposes using Management Studio over a remote internet connection. I can access the server using Management Studio while I'm on the internal office network but not from home.
Has anyone been able to do this or might recommend a third party tool as robust as Management Studio?
Thanks
View 6 Replies
View Related
Dec 29, 2003
Hi
I just installed MSDE over my Windows 2003 box and facing an small problem.
I installed it with SQL security mode and also set a password for user "sa".
Everything looks just fine using "osql" as it uses local address.
But I can't connect to my server from another computer using VS.NET Server Explorer.
It seems as MSDE is set to reject connections from outside by default.
My question is how to enable it so I can connect using my "sa" account.
Appreciate your help in advance.
View 3 Replies
View Related
Dec 30, 2005
I just reinstalled SQL Server and after reattaching my databases, I can't connect remotely. If I use "localhost" in my connection string it works fine, but I can't register my remote Enterprise Manager this way.
View 1 Replies
View Related
May 17, 2002
Hi all,
Can someone tell me if it is possible to register and connect to a SQL server that is not on my local network? I want to be able to use the Enterprise Manager to make updates to the SQL servers in my office from home. I am using SQL 7.0
Thanks in advance,
Chris
View 1 Replies
View Related
Nov 30, 1999
I'm trying to configure my workstation so that i can connect to the SQL server over the internet.
I've tried using the network connection utility and enterprise manager but am not having much luck = P
Any advice would be greatly appreciated.
Thanks!
View 1 Replies
View Related
Aug 7, 2003
Will start supporting mission critical application soon and looking a best way to remotely support it, short of dragging a laptop with me everywhere. Was going to eval PocketDBA. ANy other ideas/solutions?
View 5 Replies
View Related
Aug 29, 2000
I tried to stop SQLServer romotely through Enterprice Manager. It used to work. But, this time I got a message "a error 5 - (Access is denied) occurred while perfrming this service oetation on the MSSQLServer service." and it could not be stopped.
Do you know why and how to stop it.
Thank you ahead of time
View 1 Replies
View Related
Oct 15, 2004
I'm developing a VB app to manipulate data in a table. I've created an SQL server (local) and have successfully connected to and manipulated data in a database that I created. I would like to be able to run the app on another machine and connect to the same server. I'm having trouble determining what the server name is. Tried a few things but get the "server does not exist" message. Server is set to authenticate SQL server and windows.
Is this happening because my server is (local)? If so how do I change it to permit remote access?
Any assistance would be appreciated.
View 2 Replies
View Related
Jan 15, 2005
I'm attemping to run an sql script remotely by using osql. It works in a test environment (remotely) but when I attempt it on our production server (remotely), it fails.
Alternatively, if I run osql in the production server (locally), the script executes fine.
Should I be doing this via a different method or are there some security settings preventing me from using osql remotely in my production environment?
Thanks for any help,
Zac
View 3 Replies
View Related
Oct 24, 2005
Hi
I have heard a lot of people saying that they administe the SQL Server remotely , I mean sitting in one city , they work on the SQL Server in another city.
How is this actually achieved . Is it that the SQL Box is given a real Ip & then they connect it though the internet, but then this would not be safe , as the SQL box would be on the real Ip.
Could some one please let me knw the ways (solutions) to access & adminster a SQL Server remotely. (Not on ones LAN ) ...
Thanks & Regards
Kid
View 2 Replies
View Related
Oct 22, 2007
I have a sql server 2005 remotely, need to connect from client using sql management studio. I am unable to connect from one of the client machine and able to connect from different machine.
The tcp/ip, named pipes and sql browser is enabled in server and windows firewall is off in client.
I am getting (provider: sql network interfaces, error 26 - error locating server/instance specified)
Please throw your suggestions.
View 20 Replies
View Related
Mar 16, 2008
Hi everyone,
I'm trying to connect to my instance of SQL server 2000 remotely. I know how to do this with SQL server 2005. but since i do not have SQL server 2000 installed on my local machine.. (xp box) I would love to know how i can connect to my remote server?
Is this at all possible without SQL Server 2000 installed ? i have tried to download the personal edition / developer but I couldnt find it
If anyone knows where i can find the developer edition or if there is a trick to get SQL server 2005 to work with my SQL 2000 server it would be greatly appreciated.
thanks
View 1 Replies
View Related
Apr 15, 2008
Hi
I have SQL server admin id and password, and I want to do some create/delete new database, or mimium do some select statements. What do I need to install on my workstation in order to connect to SQL server remotely? What's the equivalent tools as SQLPlus in Oracle?
Thanks
Jirong
View 5 Replies
View Related
Mar 29, 2007
Hello, I am new to SQL Server Express, I am trying to upscale my database/Application to a SQL Server/Application with C#. All I want is to create a SQL Server service on my Office Server and manage it via my station. But I keep getting this error:
TITLE: Connect to Server
Cannot connect to SERVER.
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: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.) (Microsoft SQL Server, Error: 10060)
The thing is that I went on the Server in the Surface Area Manager, I allowed IP and and Name pipes on network. Still does not work.
When I open the Manager from my station, I see the Server but keep getting this error.
Can someone please help me. Thank you
View 12 Replies
View Related
Jan 11, 2007
Hi everyone,
Primary platform on client is XP Pro sp2 and on server Win2003 Ad.Server 64-bit
We're looking for any snippet or link related with Clustering instantiating.
We need to call our remote cluster from an ASP 3.0 page and check out if one of our Active Resource is up (in this case is a .net service) .
We suppose that it should be done for each node. It's an Active-Passive cluster.
Thanks for your time,
View 5 Replies
View Related
May 15, 2008
Hey everyone. I've been using .NET and SQL server for almost 2 years. I know most of the ins-and-outs, but we hit a bug that requires us to use remote debugging to track down. Like most people, remote debugging does not work out-of-box, but, I've actually tried most of the tips and I still cannot get it to work. Here is a summary of my problem:
------------------------------
Trying to remote debug a SQL Server 2005 database on a workgroup. I am not using CLR, just plain T-SQL.
In Visual Studio, I use the Server Explorer with a data-connection pointed to my remote server and it uses Windows Authentication. It correctly enumerates the available databases. "Step into Procedure" shows the "Run Stored Procedure" dialog with the various input/output parameters. Continuing, I get a dialog that says
"T-SQL execution ended without debugging. You may not have sufficient permissions to debug."
SQL Server is run under Windows Server 2003's window account: 'sqlusr'
Created user on local workstation called: 'sqlusr'
The 'sqlusr' on remote server and local workstation have same password, and are in the Administrator groups
'SERVERNAMEsqlusr' is in SQL Server's bulkadmin, dbcreator, diskadmin, processadmin, securityadmin, serveradmin, setupadmin, and sysadmin roles
Simply running Visual Studio 2005 Professional as my local user does not allow me to authenticate with SQL Server. Running: 'runas /userqlusr "devenv.exe"' will let me authenticate. So - user authentication is apparently working.
I imagine that 'Remote Debugging Components' are installed, since msvsmon.exe is available on the server.
RPC and RPC Locator are running on remote server and local machine
There are no firewalls on the local workstation or remote server (Windows firewall is totally disabled, no 3rd parties..)
Debugging a local SQLEXPRESS database on my workstation works.
'SERVERNAMEsqlusr' has full control over the debugging folder: 'C:Program FilesCommon FilesMicrosoft SharedSQL Debugging'
I haven't seen any errors in the remote server's 'Event Viewer/Application' list
The Stored Proc name I am executing does not contain any single or double quotation marks
SQL Server and Windows Server both share the same name 'SERVERNAME'
Edited DCOM Access Limits and Launch Limits in both the workstation and local server. Allowed 'Remote Access' for Everyone
Any help? I'm out of ideas. Thanks in advance!
View 1 Replies
View Related
Jun 13, 2007
Currently I am being told that for someone to remotely view reports that are stored in RS an individual needs to login to a PC's OS with the correct domain and user name. When they launch the browser it will them allow them access to the reports stored in RS.
This seems to limit the capabilities for a remote access
Can you go to any PC anwhere, type in the URL, and get a prompt for user name and password for access?
Will the user name and password allow restrictions to what you can see?
Is there anwhere where I can see an example of this? Like a dummy site or something?
I really appreaciate the help!
Mark
Phoenix
View 1 Replies
View Related
Oct 5, 2007
i have installed sql server 2005 standard on our server. i need to now connect to the server from a client machine within our network. do i need to install just the client tools? what are the other steps in connecting? im new to sql server, so thanks for the help.
andrew
View 3 Replies
View Related
Sep 27, 2006
Hello all,
I am having trouble getting SQL Express 2005 on Windows Server 2003
working remotely. I have set it up for TCP connections and all,
and I can connect to the server fine, but I am unable to login. How do
I go about creating accounts for the db that will allow me to access it
remotely?
View 1 Replies
View Related
Aug 11, 2007
I have both the develper and sql express installed on my laptop computer. I also have Sql Express installed on my desktop computer( Did have develper installed but removed thinking the problem was in the install). I can connect via Management console from my Desktop to laptop with out any problems. I see databases etc. I can not connect from my laptop to desktop. I get a login error. From what I can tell, the servers are configed the same on both machines. I checked Firewall settings on both machines, even turned them both off with no results. Every time I try to connect from laptop I get Log in error, and I get "Failure Audit" eror under component services.
Event Type: Failure Audit
Event Source: MSSQL$SQLEXPRESS
Event Category: (4)
Event ID: 18456
Date: 11-Aug-07
Time: 07:24:50
User: LARRY-GATLINGuest
Computer: LARRY-GATLIN
Description:
Login failed for user 'LARRY-GATLINGuest'. [CLIENT: 192.168.1.102]
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 18 48 00 00 0e 00 00 00 .H......
0008: 18 00 00 00 4c 00 41 00 ....L.A.
0010: 52 00 52 00 59 00 2d 00 R.R.Y.-.
0018: 47 00 41 00 54 00 4c 00 G.A.T.L.
0020: 49 00 4e 00 5c 00 53 00 I.N..S.
0028: 51 00 4c 00 45 00 58 00 Q.L.E.X.
0030: 50 00 52 00 45 00 53 00 P.R.E.S.
0038: 53 00 00 00 07 00 00 00 S.......
0040: 6d 00 61 00 73 00 74 00 m.a.s.t.
0048: 65 00 72 00 00 00 e.r...
I am at a loss as to what is wrong. I am migrating my Database apps to Sql from Access and need to access remotely and locally, as well as do Replication. Any ideas?
Thanks
Larry Gatlin
View 12 Replies
View Related
May 18, 2005
I have SQL Express April CTP (from VS Beta 2) installed on machineA, but I cannot connect to it from machineB using the command "sqlcmd -S machineAsqlexpress -E". This command works just fine from machineA.
View 7 Replies
View Related
Nov 2, 2006
I can't run my web application on remote pc which is connected in flan with my pc.It works on my local pc but it is not working on remote pc. i m geeting an error like as blowAn 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 used sql server 2000 for my database but i my getting error for sql server 2005 which i have never used in my web application.Here is the Exception detailsException 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)i have used coonection string as followsData Source=neptune;Initial Catalog=azim;User ID=saso can anyone give me soluion of this problem
View 1 Replies
View Related
