Hi,
I mistakenly registered a SQL 6.5 server in SQL 7.0. I would like to remove the registration entry, since I often will click it by acident, and it will fire up the SQL 6.5 EM session. However, when I right click on the server and try to select the "Delete SQLServer Registration" from the menu, that option is greyed out. Is there any way I can remove this SQLServer somehow?
Thanks,
Joe
Can anyone give me advice on how to register 6.5 servers using SQL 7.0. Every time I try and register a 6.5 servers it fails. I get an error stating that "I must upgraded the 6.5 server or later to be administered by this version of SQL-DMO". I can't upgrade the server to 7.0 because the COTS product that we are using as the front end relies on 6.5. Is there any way to do this? Or do I have to install 6.5 on my workstation as a separate application than 7.0? Someone please help?
View 2 Replies View RelatedHi! Just started playing, but when I try to register an active (on the network) 6.5 server in the 7.0 EM I get the message that I must upgrade the 6.5 server...I know in 6.5 I could access 6.0 servers after runnning a script on the 6.0 server, but so far I don`t see anything like this for 7.0. Will I end up having to run 2 versions of EM on a machine (if possible) to access my 6.5/7.0 servers? (I know I won`t be able to do anything fancy, but it is nice (under my 6.5 EM) to be able to manage server activity/db`s from one machine, regardless of them being 6.0 or 6.5!
John
How do I register servers in Enterprise Manager or access them in Query Analyzer in non-trusted domains via TCP/IP? I must administer a number of servers for which I have all the security credentials (IP addresses, Windows Administrator logon and password, sa password).
View 1 Replies View RelatedI need help with a problem that is driving me nuts and should be so easy that it is mindless. The problem is with registering SQL servers in Enterprise Manager.
The network is a routed environment with many subnets. TCP/IP addresses are assigned by DHCP and name resolution is done via WINS. The SQL clients are set to use Named Pipes as the Net-Library. The servers are using standard security. I have the correct sa password. Then I try to register a SQL server. It returns a message that it is unavailable.
The SQL box is visible in Network Neighborhood; is able to be pinged both via machine name and IP address; the msssqlserver service is running on the box. I can register the box using standard security and the same credentials in EM right on the server. Why can't I register it from a client?
Thanks in advance,
Ed
I hope someone can help me with this problem.
I need to replicate some tables from our store servers
to our corporate server. All of them are 6.5, and
the corporate server will subscribe and the stores
will publish. I have registered
all of our stores on the corporate server so that I can
enable them for replication.
The problem is that to be able to register them I had to create
a system DSN for ODBC, but that would only work if I used the
IP addresses. Unfortunately, then when I try to enable them
on the corporate server I get an error stating that name (which
is the IP address) is not a valid object identifier.
In ODBC I did actually use a real name (not an IP) for the
name, a normal description, and the IP is in the Server
field. Is there some way to use an alias? What am I doing wrong?
I have installed 7.0 on my desktop and I am trying to use the Enterprise Manager. I am trying to register 6.5 servers and keep getting the SQL Server Enterprise Manager message "Warning - The client and server codepages do not match. Some ANSI character mappings may not be possible".
I have been told that I can install 6.5 then 7.0 but it is not available.
Anybody have any solutions?
Thanks in advance,
Ivan
Hi,
I've SQL 7 running on windows NT 4.0 server.
From my Sql server when I tried to register a remote server in the same office, I couldn't.
When I get the new registration wizard, I could see the server(s) I want to register. But when I finish all the steps in the wizard, it says: Unable to establish client connection.Connection Open(Create File).
I tried using both sql standard and win nt security (logins) but didn't work.
Help please.
Thanks,
Kiran
I have a report that was designed using SQL Reporting Services that sits on a SQL reporting server. It's nothing too exciting, it is essentially a three page application with legal jumbo on pages 2 and 3 and applicant data in fields on page 1.
We use rectangles to force page breaks to page 2 and to page 3.
When running the report on the report server, it shows and prints fine.
When running the report from the QA website internally, it shows and prints just fine.
When running the report from the production website from a machine internally, it shows and prints just fine.
When running the report from outside of the company network, the report is jacked. It obliterates large chunks of text, crams text together, and creates blank pages.
I need help in determining where I even begin with trouble shooting this!
can anyone tell me if they know of a way to automate the update process from development servers to live server, with little interference from an administrator
I have a development team that are constantly updating their databases along with their ASP code, and want to publish changes an a weekly basis. They have asked me for a way to take their new structures, tables, procedures etc, and copy them to the live servers, but NOT to interfere with existing customer data.
Funny I know – and I hate the idea btw :(
Any references, contacts, 3rd party tool recommendations welcome,
Thanx,
Darren
I am in the middle of a major migraton project, moving from x86 SQL 2000 to IA64 SQL 2005. I have a business need to link to several legacy servers. I have a number of problems I am trying to solve.
1) Linking a Kerberos server to a non-Kerberos server.
2) Linking x64 or IA64 servers to x86 servers.
3) Linking SQL 2005 to SQL 2000.
Two of the errors I am encountering are:
------------------------------
TCP Provider: An existing connection was forcibly closed by the remote host.
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
OLE DB provider "SQLNCLI" for linked server "SCDC250DB" returned message "Communication link failure".
(Microsoft SQL Server, Error: 10054)
------------------------------
And
------------------------------
The OLE DB provider "SQLNCLI" for the linked server "SCDC250DB" reported an error. Authentication failed.
Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "SCDC250DB".
OLE DB provider "SQLCLI" for linked server "SCDC250DB" returned message "Invalid authorization specification".
(Microsoft SQL Server, Error: 7399)
If someone has worked through these problems before, I would appreciate it if you could direct me to the relevant documentation to resolve these issues.
Thanks!
Brandon Forest
Database Administrator
Data & Web Services Team
Sutter Connect Information Technologyforesb@sutterhealth.org
Does anyone know what SQL Server uses to identify other servers which contain SQL Server, when you attempt to register a new server through enterprise mgr? For instance when you go through the new sql server registration wizard, the second screen allows you to choose what server you would like to register, and it shows you the available servers on the lan that contain sql server 6.5 or 7.0. What is enterprise mgr using to locate the other servers containing SQL Server? Thanks in advance.
View 2 Replies View RelatedI just created a new db on a programmer's machine. Now I cannot register his sql server on my sql server. It doesn't like 'sa'. I can connect as 'administrator' but then I cannot do anything. Seems like the logins are messed up. I am not able to execute any stored procedures as administrator.
Any ideas besides reloading sql?
Thanks.
When using MSDE or SQL7 as the back-end to Access2000 projects (adp),
the examples often have an .mdf file to match such as say NorthwindCS.mdf
The instructions are:
1. set this file aside,
2. create a database with this name then
3. stop SQLServer,
4. copy own file to msql7data...
5 use it....
although this soemtimes works, i mostly get a "suspect" database
I was hoping to fix this with DBCC REPAIR, but support for this command seems
to have disappeared
Help
Hi,
I have recently installed SQL Server 2000, And trying to register a remote SQL 7 server, through enterprise manager which fails with the following error message: Timeout expired
I am able to connect to the same server using Query Analyzer.
I was able to register this server from the same machine, prior to the installation of SQL 2000. Also, I am still able to connect to other SQL 7 servers, with SQL 2000 enterprise manager.
Any Ideas?
Over the weekend we changed ISPs on our SQL Server 2000 machine. The only configuration change was the IP address. I'm able to register the server from client machines using EM which are on the same network, but I can't register it from home. I've verified the IP address, username/password etc and the connection just fails with the message 'Sql Server does not exist or access is denied.' Could this be a port issue? Any ideas? Thanks.
View 4 Replies View Relatedis it possible to register an SQL server any other way than SQL Enterprise Manager?
If so, how?
Preeti.
Hi,
How to register a Remote SQL SERVER from a node in Local Area Network?
Please pardon my ignorance, but I am using MS SQL2000...On system start upthe Server Service Manager defaults to server "BACK" which is not evenregistered in the SQL Enterprise Manager. Enterprise Manager shows only oneserver " OFFICE" which is the one I want to default to. How do I remove the"Back" server completly from the system?thank you
View 3 Replies View RelatedThe organization I work for will be converting to SQL Server 2005 in the near future so I downloaded the free 90 day trial to familiarize myself with the software. I've installed the software and my plan now is to go through the Tutorials. I need to access AdventureWorks sample database. AdventureWorks did not download upon initial setup so I've downloaded/installed it into what appears to be the correct folder: c:ProgramFilesMicrosoft SQL Server90ToolsSamples. I cannot, however, seem to locate it within SQL Management Studio. As advised by the tutorial I've tried setting up a New Server Registration but I can't seem to locate AdventureWorksDB when I'm browsing for it under the Connect to Database:' option under the "Connection Properties" tab of New Server Registration.
I am familiar with database development as it relates to MS Access but I realize this is a whole new ball of wax. Any advise would be appreciated as it relates to this problem but also any information, i.e., very basic books on learning SQL Server would also be appreciated.
Treasa
Hi all
When I'm installing sql reporting service I get an error that says "ASP.NET is not installed or is not registered with your web server."
I have iis installed, all of .net, and just installed .NET Framework Redist version 1.1
Can anyone tell me what I need to do to register ASP.NET or what I've done wrong.
Thanks for your help
Jerry
Ok, well I just installed Visual Studio.NET 2003 on my PC, and to
prepare for next years courses I thought I might get going on some of
the exercises. But I am rather new to this and when I try to expand
"SQL Server" in the "Server Explorer Window" I get this message.
Could not automaticly discover any SQL Server instances.
Choose Register SQL Server instance from the shortcut menu if you know there are SQL Server instances on this machine.
From there all I know is that I can right click on "SQL Server" and
chose register new instance, but I do not know what to enter, and it
suggrests leaving it balck but that doesn't work. I will get an
instance but when I try to expand it another error pops up.
So as you can see I have no idea what I am doing when it comes to SQL Server, can any one help me with this?
Thanks again,
MCCCStudent
hi ,
One of my user to register a server , then he is getting following error.
Unable to connect to server (reason:[sql server] login failed-- user:login1.
Reason : Not defined as a valid user of a trusted sql server connection)
Register anyway.
He is having permissions to the specified server. This server is 65.
thank u.
--Kavira
Hi folks,
i'm at a loss as to why i can not register a SQL 6.5 server in SQL 7.0 Enterprise Manager. When i right click the 6.6 group there is no 'New SQL Server Registration...' as you get in the SQL 7.0 group. Highlighting the 6.5 group and clicking the toolbar button (which is actually visible) does nothing either. But, funnily enough when i installed Enterprise Manager another 6.5 server was automatically registered! Even more wierd is the fact that i can connect through OK with the ISQL utility to my 6.5 server (the one i can't register) and query it, fine.
How do i register it in the Console Root? It's definatly 'connectable' just that i can't register the thing! I bet i'm being really stupid (no comments folks!)
Cheers,
Kyle.
*8^)
hi, I have just installed Ms sql 6.5 and tried to register the server, I typed a name and did not get any response. This installation was on a single pc which is not connected to the network... any idea of why the server is not responding. Do I need to give a name to the pc before I installed the sql server and then use register the server...
thank for your help
Ali
I cannot register, from my W98 workstation, an instance of SQL 2000. I just installed SQL2000 (evaluation edition) on my server. Previous to my install I had MSDE installed on the server and successfully registered it from my W98 workstation. When I installed the SQL2000 it recognized there was already a version of SQL Server (MSDE) on the server and said that was the default. Hense, I installed the SQL 2000 as an instance using the format servernameinstance. I can see both of them on the server EM with no problem--I just can't register the SQL 2000 instance from my workstation. When asked for the server name I use the format servernameinstance as it appears in the EM on the server. However, I get the error that the server does not exist or access is denied.? What could I be overlooking? Any help would be much appreciated.
Thanks,
Eugene Jenkins
Hi all,
I have installed SQL Server 2k personal ed on Win xp and now I want to add another instance other than that one I added when installation.But I do not know how? I used EM and its wizard but it says could not find server or access is denied...
-any quick help is appreciated
SQL Server 2012 two node cluster.I was checking the authentication after registering SPN and found the following.When the windows cluster is in one node and the SQL Server role is failed over to the other, windows logins to SQL Server use NTLM authentication.Or is it just my SPN is not working properly ?
View 0 Replies View RelatedHello
I am trying to register a SQL Server 2000 on a client machine. It was workig fine , until yestarday when he moved and got a different system IP. But one of the SQL Server 'A' is getting connected. But when I try to register the server 'B' its giving an error " SQL Server does not exist or access denied". I am giving correct login credintels. When I tried to ping ( using cmd) the Server 'B' , the system was able to connect.
What might be the problem.
Thanks for the help.
Hello, im new to sql server 2005. Ive been handed the task to register a database from server A virtually on server B.
I don't know how this is done. Can anyone please help me
Thanks in advance Jamm.
Hi all,We have standardized on Hyperion as our reporting tool. So far I haveonly set up a couple of Access databases as data sources for it. Nowthere is a request to report off our eOn (telephony management) SQLServer database using Hyperion. The eOn SQL Server box is in aworkgroup that is not part of the rest of our domain. (We only haveone domain because we don't have a "forest", whatever that means.) Itis behind a router owned by eOn along with a PBX and some other stuff.Setting up a data source for Hyperion requires creating a special datasource file called an .oce on the box where the Hyperion fat client(required for most administrative tasks) resides, and also setting up adifferent special data source file called a .das on the server wherethe Hyperion services run. (The analysts and end-users do not have thefat client, their access is web-based.)I have to register the eOn SQL Server by using the IP address and SQLServer authentication. (I was told that I can't use Windowsauthentication because it is not in the domain.) From the box onwhich the Hyperion fat client resides, I cannot register the eOn SQLServer. The error message is "timeout expired". Tracerting indicatesthere are no intermediate hops when attempting to connect from thisVLAN. From my desktop, which is on a different VLAN, I can connect toand register it. This trip includes one hop at our 6509. From one ofmy servers which is on the same VLAN as the fat-client box, I am ableto connect and register. On the fat-client box I tried deleting andre-registering another SQL Server and there was no problem.The IP address I have to use to connect to the eOn SQL Server is *NOT*the actual IP address of the box it resides on, but rather the eOnrouter, which translates it to the address of the server. We have nocontrol over this, eOn creates this setup. I'm not sure how it knowswhich of the devices behind it a given message is for.Ideas?
View 3 Replies View RelatedOne of our developers is trying to register a database that is notlocal to his computer with his Windows domain account versus sqlserver. When registering the server he gets an error message that SQLServer does not exist and he is unable to register the databasealthough his windows account is has a login at the remote database. Idon't want to create a sql login for him I would rather he login withis windows account, anyone have any ideas why this is happening?Thanks,Alan
View 1 Replies View RelatedAll,
I am able to "CREATE ASSEMBLY" for the stdole.dll without issue, however, I receive the warning:
Warning: Assembly "stdole" was built using version v1.0.3705 of the
.NET Framework. SQL Server currently uses version v2.0.50727.
(Microsoft SQL Server, Error: 6215)
I am unable to find a PIA for stdole that is .NET 2.0. Has anyone resolved this warning? Can I create a 2.0 PIA myself without causing other problems?
Thanks in advance for your thoughts.