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
I have SQL Server 2005 Express installed on a windows server 2003 standard edition. I have configured the windows firewall to allow exceptions for sqlservr.exe and sqlbrowser.exe. I have enabled remote and local connections using tcp/ip & Named Pipes through the Sql Server Surface Area Connection utility. I am able to telnet into the server with: telnet <server ip> <1433>.
Here is the strange part: I am able to connect to the Sql Server remotely from a development machine via Sql Server Management Studio Express, but I am unable to connect to the Sql Server from the same development machine by registering it in Sql Server Enterprise Manager...Is it possible to register SQL Express through Enterprise Manager?
When registering the SQL Express DB in Enterprise Manager I tried both just the (IP Address) of the server and the (IP AddressSQLExpress) as the server/host but I am getting the following errors from enterprise manager:
Just the (IP Address) as the server/host:
Invalid Connection.
ConnectionOpen( Invalid Instance())
(IP AddressSQLEXPRESS) as the server/host:
Sql Server does not exist or access denied. ConnectOpen(Connect()).
Any idea why I can€™t register/mount the instance remotely in Enterprise Manager
but I can in Sql Server Management Studio Express?
Thanks,
Greg
Hi,
Iam learning asp.net myself .
I've installed SQL Server7.0 in my PC.
How will I register a server
for example: localhost using enterprise manager.
I keep getting error message:
Specified SQL Server not found
Please help with registering a server.
Thanks
Abi.
1)I AM NOT ABLE TO REGISTER MY SERVER (S1) WITH ANOTHER SERVER (S2),
BUT AT THE SAME TIME I AM ABLE TO REGISTER SERVER (S2) FROM MY ENTER PRISE MNAGER.
WHAT COULD BE THE PROBLEM?
IF ANY KNOW PLEASE SUGGEST
THANKS
When converting from 6.5 to 7 the Servers I had registered under 6.5 were still available. When I try to connect to them the old 6.5 Enterprise Manager starts up and I really like this ability.
I would like to register a new 6.5 Server while running 7.0
I'm developing on 7.0 and thus would like to keep my machine running 7, but need to add 6.5 servers on occasion. Any suggestions.
(I think if I switch to 6.5 and register that will work, but don't want to switch)
I loaded a microsoft SQL server training CD. When i go to enterprise manager i am prompted for a server. I checked the online books and it says that i should use the compter name. This does not work. My dialog box that i am using to enter the computer name, logon ID, and password is titled connect server. The documented information has Register server for the title of the dialog box. Is there a difference? What am i doing wrong? I am not able to connect the server at all. This is a training disk and is only good for 120 days. I am running out of time and i have not even started.
Any help would be greatly appreciated.
Really would like some help from anyone who has experienced this problem.
I installed SQL server v6.5 on my machine. I selected communication options TCP/IP and Named Pipes and took all the other defaults. After receiving the `installed ok` message, I went on to register the server and received the following msg.
A connection cannot be established to A0194876 [DB Library] Unable to
connect. SQL server is unavailable or does not exist.
My machine name is, A0194876. I have tried changing the machine name, rebooting, etc. but nothing works.
Hello,
We are facing problems in registering server in MS-SQL Server 6.5.
We are getting CODE EXCEPTION error. We tried unistalling SQL Server
and Re-Installing again. In spite of this, it is still giving the same error.
We happen to change the HOST name of the NT Server m/c on which
the SQL Server resides once.
What could have possibly gone wrong. Any help would be greatly appreciated.
Thanks.
Howdy,
I installed SQL Server 2000 (Standard Edition) on my desktop running Win2K Pro. During installation, a message indicated that only the client tools could be installed on this version (I assume it was referring to Win2K Pro). No errors were encountered during installation.
Now, I am trying to figure out how to get started working with SQL Server 2000. I opened the Enterprise Manager and have tried to register a SQL Server using the wizard to register a SQL Server. I then selected my computer name under the available servers list and then chose Windows Authentication to connect. On the next wizard screen I then chose to add the SQL Server to the default group name (SQL Server Group). After clicking on the Finish button, the Status block on the last screen indicates "SQL Server does not exist or access denied."
Any idea what's happening? What am I doing wrong?
TIA.
Hi all,
I'm having difficulty with registering a new SQL server across
a network. I'm guessing it's something to do with the authentication method, but as of yet I can't get it to work.
I recieve the message
"Login failed for user 'computername/Guest' "
Curiously, doing things the other way round (registering this server on the other one across the network) works absolutely fine, and as far as I can tell I have them set up exactly the same.
Any help would be very much appreciated!
Ben
I want register a server it is on other PC is a server, BUT IT SHOW TO ME A MESSAGE OF ERROR:
Errors ocurred while connecting to ----ip-----
Cannot open connection to Analysis server ----ip-----
Can not connect a server ----ip-----. not this in operation or this occupied
Do you still Want to register this server
Got error message when trying to register sql server:
NYCPI - SQL Server does not exist or access denied. ConnectionOpen(connect()
where NYCPI is my remote server name which has sql server in it.
When the registration wizard display a list of available servers, NYCPI appear twice in the available server list. But this problem is not exist in another machine. I tried register this sql server from another server and it is working in the second machine.
Any ideas?
Thanks!
Hi, here is my problem
I am trying to conncet to an SQL Server that is on the net. The name of the server looks like : sqlServer.TheCompanyOwingIt.Com and it listens to port 2433
I am opening enterprise manager and trying to connect ,giving the name of the server and the credentials but no luck. I also tried opening hte client Network utility , created an alias for that server, specifying 2433 as the port but no luck again. Finally i tried to change the port of my sql server to be 2433 (instead of 1433), no luck again !!! Any ideas ? (there is no firewall running on the PC, but there is a router which might (?) cause the problem ? (i tried to port forward 2433 , but i am not sure if i did it correctly).
Any ideas, suggestions will be greatly appreciated
Thx in advance
Theodore
I am currently trying to connect to a SQL Server instance with my host provider. I am having issues trying to connect to it.
I am using a Linkysys router and I have opened up the ports that SQL Server needs but I am getting an error - "SQL Server does not exist or Access denied". I've contacted the support but they are telling me it is an error on my end.
Has anyone experienced this issue before?
Thanks in advance for the help.
Hi friends,
How to register SQL SERVER in EM using IP Adderess.
TIA
Raj
I have installed SQL6.5 on my NT4.0 server.
I go into the enterprise manager. There are currently no registered servers. I try to add a server under the SQL 6.5 group and get the following message:
"Unable to connect to Server(reason [SQL Server Login failed]. Register Anyway?"
The service is running. I can login through the command prompt, but when I type select @@servername it comes back as NULL.
I have tried both my NT SA account as well as the SQLExecutiveCmdExec account. TIA - pwb
Hi,
In Enterprise Manager when I try to register a server, I get the following error mesage:
Login failed for 'sa'. Not associated
with a trusted SQL server connection
What does all of this mean? How do I create a "trusted SQL server connection"?
Kindly assist.
Information:Server A: SQL Server 2000 Enterprise Edition. OS is Windows 2003 ServerEnterprise Edition. SQL Service pack is 3a. Member of domainABCDomain. Server A is going to function as a Distributor.Location: New York.Server B: SQL Server 2000 Enterprise Edition. OS is Windows 2003 ServerStandard Edition. SQL Service pack is 3a. Member of domainABCDomain. Server B is going to function as a Subscriber.Location: London.Server C: SQL Server 2000 Enterprise Edition. OS is Windows 2000 AdvancedServer. SQL Service pack 3a. Member of domain ABCDomain. Server Cis going to function as a Publisher. Location New York.Problem: I am setting up a test replication environment prior to going livewith a replication from New York to London. When I try to registerServer A on Server B, I get the error: ‘SQL Server does not exist oraccess denied'. I get the same error when I try to register ServerB on Server A. Both boxes can ping the other. I am able toregister Server C (Publisher) on both Server A and B as well asregister both Server A and B on Server C.I would appreciate your input as to what could be causing thisproblem as well as a possible solution.Thank you in advance.
View 2 Replies View RelatedI have a user who can't register the SSIS server in SMS. What permissions do I need to give him to allow this ... without making him sysadmin of course?
View 2 Replies View Related
Hi all,
I am having seriuos problems getting VoIP traffic into and out of my network via the ISA server which we just newly installed.
My network topology is such that the phones i am using for the VoIP service, sitting inside my network and behind the ISA server, have to register to some remote proxy server outside my network and as soon as it registers i can begin using the service. The VoIP service is on the platform of SIP and uses udp ports 5060 and 8080.
I have permitted the necessary ports on the ISA server for the service being UDP port 5060 and 8080 but still cannot get my VoIp traffic through the server.
Please i need some help here as regards something i am supposed to do or something i am not doing right on the ISA server to permit my traffic.
I am a newbie to this Microsoft ISA server and i hope you all understand
Thanks in anticipation to your replies.
Leonard.
I want to create a database on my local machine and work with it. But I am not able to see the name of my local server under "Database Engine" in the list of "Registered Servers".
Options I tried:
(1) In Registered Servers window, On Database Engine, I right clicked and in that selected "Update Local Server Registration"
(2) In Registered Servers window, On Database Engine, I right clicked and in that selected "New" -> Server Registration.
In "New Server Registration" Window, in "Server Name" drop down I clicked "Browse for more" but still in "Browse for Servers" window, I am not able to see the name of my local server in "Local Servers" tag under Database Engine.
(3) If I do File -> Connect Object Explorer -> Connect to Server window in "Server name" drop down box, if I click "Browse for more", I am able to see local server name eg. "XYZ" under Analysis Services, Reporting Services, and Integration Services but not under "Database Engine"
Please help me create a new database engine in SQL Server 2005 or list my local server under "Database engine" ?
Thanks
I'm trying to installed SQL 2000 on a NT 4.0 Platform locally.
When I followed the wizard and specified the name of the server which is my machine name. I received the following message : "SQL Server does not exist or access denied. Connection open Connect()".
Any Suggestions!
Thanks in advance,
Vic
How I can register MSSQL Server 2000 by IP Address-
I installed MSSQL Server 2000 sp3a, Enterprise edition on windows 2000 advanced server box with sp4. It’s primarily give instance with name like servername/sqlindia, Where sqlindia is instance and servername is physical machine name.
I would like to registration of sqlserver instance by IP Address. How I can do it.
Thanking You
R.Mall
Hi,
When I try to register a server in Analysis Services I get a error saying 'Automation error' and I also get a message saying Unable to open Registry Key 'SOFTWAREMICROSOFTOLAP ServerOLAP Manager'
Can someone please help.
Hi,
I am really new to SQL Server. I have trying to create/register a server. I came to know that I need to go to Query Analayser and then register a Server. Then in Enterprise Manager I need to register a Group. I did everything.
But...
Here is the error.
Unable to connect server.
Server: Msg 17, Level 16, State 1
[Microsoft] [ODBC SQL Server Driver] [Shared Memory]
SQL Server does not exit or access denied.
I really appreciate if u can give me steps. Thanks, Padma.
Hi,
I'm trying to silently(quiet mode) install Sql Server 2005 and our application.I created a custom wrapper and included all the files and folders extracted from SQLEXPR.exe.
So when I execute this customized setup its throwing an error : Could not register Program Files/Microsoft SQL Server/90/Shared/msxmlsql.dll
If I ignore the above error its throwing similar errors for almost all the files under Program Files/Microsoft SQL Server/90/Shared folder.
kindly help me to resolve the issue.
Thanks & Regards
Krish
I tried to install SQL Server 2005 in a fresh installed Windows 2003 SP2. And this server is a workgroup member, not a member of a domain.
The services (Database service, integration service, reporting services and so on) work fines, but the other components, such as SQL XML 6.0 , SQL Server management Studio cannot be installed. And I have tried several times on a fresh-installed windows 2003 sp2.
I checked the log, I found the following error,The SQL Network Interface library could not deregister the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Administrator should deregister this SPN manually to avoid client authentication errors.
2007-11-18 15:40:59.35 Server The SQL Network Interface library could not deregister the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Administrator should deregister this SPN manually to avoid client authentication errors.
Then the installation existed with the error message "There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information. ".
I never had this problem and this time, I really got the trouble and do not have solution.
Who have ever encounter this problem? Or someone can help me?
Thanks.
Hi
We have a situation where we run two instances of SQL server 7.0 on two separate machines. These are both administrated from one computer using the Enterprise Manager.
Now we want to be able to run queries (via query analyser) from our administration machine on an Sql server 6.5 computer running on a different part of the network. Enterprise manager from version 7.0 seems to find the SQL 6.5 server but is unable to register that server. Is this in any way possible?
Thanks
TS
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
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 RelatedI'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!
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
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.