Create/Register A Server/ Server Group -- Trouble.
Feb 23, 2002
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.
I've got this set of registers (just an example) after ordering by the first 3 columns:
value_A value_B value_C ID date 1 2 3 YVIR 29/08/2015 1 2 3 ANTE 27/04/2015 1 2 3 REGO 20/02/2015
I need to get as a final result:
value_A value_B value_C ID date 1 2 3 REGO 29/08/2015
In other words, I need to get, after ordering the result by the date field, the most recent date but at the same time the oldest ID in the list.
I've been trying to do this with the group by clause:
select value_A, value_B, value_C, min(ID), max(date) -- or max(ID) from table group by value_A, value_B, value_C
But in the field ID I'm getting the wrong result because this value is been associated with the alphabetic order.
In access this query involves the function LAST, but in SQL I have not found a good way to perform this. And I am asking because I have seen some possible solution but almost all of them involving the UNION operation, but my problem is, this table can have more than 350.000 registers.
This table is update by some one else, I just can access the information and use it as a source.
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
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" ?
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?
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
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.
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.
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.
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.
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."
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.
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
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.
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
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.
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
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.
I 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?
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()".
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.
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'
Not 100% sure I'm doing this correctly in the first place but I have an orders table that has a FK back to the employee that processed the order and the time it was ordered. What I'd like to do is get the most recent order for each employee but this seems to be escaping me... I tried something like.
SELECT Employee, MAX(OrderDate) FROM Orders GROUP BY Employee
This works all fine and dandy but I need to get other data from the most recent row.
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.
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?
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?
Hi, I am having trouble getting my query right. i am using a stored procedure to retrieve this data and bind it to my grid view. Problem: I can't associate a field with a column that i am returning with my record set. Details: I have query that i want to return 9 columns (UserName, Pre-Approved, Processing, Underwriting, Conditioned, Approved, Docs Out, Docs Back, Conditions Met). The username column lists all loan agents. I want the other 8 columns to list the name of the borrower (crestline..borrower.lastname) that is associate with that loan agent and that loan state. Each time a record is found where there is a valid loan agent (UserName) that meets the 'where' conditions, there will be a borrower. the 'LoanKey' field is a primary key that lets me get the borrower name from the borrower table. I dont know how to construct my query such that those borrower names get associated with their respective column header. if the query works, my Gridview should look like this ('Name' refers to the borrower name) UserName | Pre-Approved | Processing | UnderWriting | Conditioned | Approved | Docs Out | Docs Back | Conditions Met Bob | | | | Name | | | | Bob | | Name | | | | | | Bob | | | | | | | Name | Steve | | | Name | | | | | Steve | | | | | | Name | |
Here is my sql call: SELECT cfcdb..users.username, crestline..borrower.lastname,CASE WHEN crestline..loansp.LoanStatus='Pre-Approved' THEN crestline..loansp.LoanStatus ELSE NULL END AS 'Pre-Approved',CASE WHEN crestline..loansp.LoanStatus='Processing' THEN crestline..loansp.LoanStatus ELSE NULL END AS 'Processing',CASE WHEN crestline..loansp.LoanStatus='Underwriting' THEN crestline..loansp.LoanStatus ELSE NULL END AS 'Underwriting',CASE WHEN crestline..loansp.LoanStatus='Conditioned' THEN crestline..loansp.LoanStatus ELSE NULL END AS 'Conditioned',CASE WHEN crestline..loansp.LoanStatus='Approved' THEN crestline..loansp.LoanStatus ELSE NULL END AS 'Approved',CASE WHEN crestline..loansp.LoanStatus='Docs Out' THEN crestline..loansp.LoanStatus ELSE NULL END AS 'Docs Out',CASE WHEN crestline..loansp.LoanStatus='Docs Back' THEN crestline..loansp.LoanStatus ELSE NULL END AS 'Docs Back',CASE WHEN crestline..loansp.LoanStatus='Conditions Met' THEN crestline..loansp.LoanStatus ELSE NULL END AS 'Conditions Met'FROM cfcdb..usersinner join (crestline..loansp inner join crestline..borrower on crestline..loansp.loankey = crestline..borrower.loankey)on crestline..loansp.fstnamelo=cfcdb..users.firstname AND crestline..loansp.lstnamelo=cfcdb..users.lastnameinner join cfcdb..users_roleson cfcdb..users.username = cfcdb..users_roles.usernamewhere cfcdb..users.active = 1 AND cfcdb..users_roles.groupid = 'agent'AND crestline..loansp.enloanstat <> 'Closed' AND crestline..loansp.enloanstat <> 'Cancelled' AND crestline..loansp.enloanstat <> 'Declined' AND crestline..loansp.enloanstat <> 'On Hold'order by cfcdb..users.username asc
