Register Hasn't Been Updated
hi,
i have a programmer problem. When i exec a update sql with odbc
drivers, in database i dont update register, but if i exec the execute
sql in manager, then i update the register. Someone knwos what is
happening?
thanks for answer.
View Complete Forum Thread with Replies
Related Forum Messages:
Fixing A Corrupt Database That Hasn't Been Flagged Yet.
I'm attempting to move a database from a production server to a test server. The database appears to be corrupted, and running dbcc checkdb brings up this message: CHECKDB found 0 allocation errors and 12 consistency errors in database 'ProductionDB'. repair_fast is the minimum repair level for the errors found by DBCC CHECKDB (ProductionDB ). DBCC execution completed. If DBCC printed error messages, contact your system administrator. I can't generate a workable backup from the database to perform a restore option, and the DTS wizards are failing as well. It seems that the only option is to do a detach/attach db procedure, but I'm concerned that SQL Server may fail to re-attach the database, since it performs consistency checks when you perform that operation. I'm also concerned that running any repair commands with dbcc might "push the database over the edge" (as a colleague told me, since the database is in a bad state). The odd thing is that the application using the database still works fine and SQL Server has not flagged the db yet, but like I said - can't generate workable backups from it and the wizards are failing. I noticed that older backups on the server (that do work) contain transaction logs that are 13 gigabytes, while the current ldf file is only 1.6 gigabytes. I'd greatly appreciate any insight as to how I can fix this database. Here's the errors that were listed in the output of dbcc checkdb: Server: Msg 8951, Level 16, State 1, Line 1 Table error: Table 'UserObject' (ID 1678785188). Missing or invalid key in index 'Idx_UserObject_userid' (ID 2) for the row: Server: Msg 8955, Level 16, State 1, Line 1 Data row (1:89269:7) identified by (RID = (1:89269:7) u_logon_name = '{7560bada-eb3e-4530-92af-60b092b838a1}') has index values (g_user_id = '{C7D73FF4-D6BD-42E1-9ACB-DAE483AE9417}' and u_logon_name = NULL). Server: Msg 8952, Level 16, State 1, Line 1 Table error: Database 'ProductionDB', index 'UserObject.Idx_UserObject_userid' (ID 1678785188) (index ID 2). Extra or invalid key for the keys: Server: Msg 8956, Level 16, State 1, Line 1 Index row (1:95065:1) with values (g_user_id = '{C7D73FF4-D6BD-42E1-9ACB-DAE483AE9417}' and u_logon_name = '{7560bade-eb3e-4530-92af-60b092b838a1}') points to the data row identified by (). Server: Msg 8951, Level 16, State 1, Line 1 Table error: Table 'UserObject' (ID 1678785188). Missing or invalid key in index 'Idx_UserObject_emailaddress' (ID 3) for the row: Server: Msg 8955, Level 16, State 1, Line 1 Data row (1:89269:7) identified by (RID = (1:89269:7) u_logon_name = '{7560bada-eb3e-4530-92af-60b092b838a1}') has index values (u_email_address = NULL and u_logon_name = NULL). Server: Msg 8952, Level 16, State 1, Line 1 Table error: Database 'ProductionDB', index 'UserObject.Idx_UserObject_emailaddress' (ID 1678785188) (index ID 3). Extra or invalid key for the keys: Server: Msg 8956, Level 16, State 1, Line 1 Index row (1:148838:28) with values (u_email_address = NULL and u_logon_name = '{7560bade-eb3e-4530-92af-60b092b838a1}') points to the data row identified by (). Server: Msg 8951, Level 16, State 1, Line 1 Table error: Table 'UserObject' (ID 1678785188). Missing or invalid key in index 'Idx_UserObject_firstname' (ID 4) for the row: Server: Msg 8955, Level 16, State 1, Line 1 Data row (1:89269:7) identified by (RID = (1:89269:7) u_logon_name = '{7560bada-eb3e-4530-92af-60b092b838a1}') has index values (u_first_name = NULL and u_logon_name = NULL). Server: Msg 8952, Level 16, State 1, Line 1 Table error: Database 'ProductionDB', index 'UserObject.Idx_UserObject_firstname' (ID 1678785188) (index ID 4). Extra or invalid key for the keys: Server: Msg 8956, Level 16, State 1, Line 1 Index row (1:148845:28) with values (u_first_name = NULL and u_logon_name = '{7560bade-eb3e-4530-92af-60b092b838a1}') points to the data row identified by (). Server: Msg 8951, Level 16, State 1, Line 1 Table error: Table 'UserObject' (ID 1678785188). Missing or invalid key in index 'Idx_UserObject_lastname' (ID 5) for the row: Server: Msg 8955, Level 16, State 1, Line 1 Data row (1:89269:7) identified by (RID = (1:89269:7) u_logon_name = '{7560bada-eb3e-4530-92af-60b092b838a1}') has index values (u_last_name = NULL and u_logon_name = NULL). Server: Msg 8952, Level 16, State 1, Line 1 Table error: Database 'ProductionDB', index 'UserObject.Idx_UserObject_lastname' (ID 1678785188) (index ID 5). Extra or invalid key for the keys: Server: Msg 8956, Level 16, State 1, Line 1 Index row (1:148888:28) with values (u_last_name = NULL and u_logon_name = '{7560bade-eb3e-4530-92af-60b092b838a1}') points to the data row identified by (). Server: Msg 8951, Level 16, State 1, Line 1 Table error: Table 'UserObject' (ID 1678785188). Missing or invalid key in index 'Idx_UserObject_datecreated' (ID 6) for the row: Server: Msg 8955, Level 16, State 1, Line 1 Data row (1:89269:7) identified by (RID = (1:89269:7) u_logon_name = '{7560bada-eb3e-4530-92af-60b092b838a1}') has index values (d_date_created = Jul 29 2005 2:53PM and u_logon_name = NULL). Server: Msg 8952, Level 16, State 1, Line 1 Table error: Database 'ProductionDB', index 'UserObject.Idx_UserObject_datecreated' (ID 1678785188) (index ID 6). Extra or invalid key for the keys: Server: Msg 8956, Level 16, State 1, Line 1 Index row (1:366496:18) with values (d_date_created = Jul 29 2005 2:53PM and u_logon_name = '{7560bade-eb3e-4530-92af-60b092b838a1}') points to the data row identified by (). Server: Msg 8951, Level 16, State 1, Line 1 Table error: Table 'UserObject' (ID 1678785188). Missing or invalid key in index 'Idx_UserObject_datelastchanged' (ID 7) for the row: Server: Msg 8955, Level 16, State 1, Line 1 Data row (1:89269:7) identified by (RID = (1:89269:7) u_logon_name = '{7560bada-eb3e-4530-92af-60b092b838a1}') has index values (d_date_last_changed = Jul 29 2005 2:53PM and u_logon_name = NULL). Server: Msg 8952, Level 16, State 1, Line 1 Table error: Database 'ProductionDB', index 'UserObject.Idx_UserObject_datelastchanged' (ID 1678785188) (index ID 7). Extra or invalid key for the keys: Server: Msg 8956, Level 16, State 1, Line 1 Index row (1:393264:18) with values (d_date_last_changed = Jul 29 2005 2:53PM and u_logon_name = '{7560bade-eb3e-4530-92af-60b092b838a1}') points to the data row identified by ().
View Replies !
Linked Reports Not Being Updated When Master Report Is Updated
Since updating to SQL Server 2005 SP2 I've noticed two things about Linked Reports. 1. I do a lot of 'Snapshot' reports. With SP-1 if I updated a master report and made any changes to the Parameter List - it undid all my custom parameter changes on linked versions (restored to the Master Reports Defaults). While this is no longer happening with SP2 - it is still 'unhiding' the parameters. 2. With SP-1 if I added/deleted columns or made other changes to the report structure - the linked reports would pick up on the changes with their next refresh. With SP-2 I'm finding that I have to 'Re-link' the linked report back to the master report before the changes are refreshed. This is very time consuming especially with each report having 8 or more Snapshot reports pre-set up. Am I missing something - or is this a 'bug'... Any help would be appreciated...
View Replies !
Save Updated Date When Row Is Updated
Hi,I want to save the last modification date when the row is updated. I have a column called "LastModification" in the table, every time the row is update I want to set the value of this column to the current date. So far all I know is that I need to use a trigger and the GetDate() function, but could any body help me with how to set the value of the column to getdate()? thanks for your help.
View Replies !
Cannot Register To EM
Hi all, I am tring to register a SQL Server 6.5 to EM on a Win95 machine which has Admin tools only.I have tried to change the Client Configuration for both SQL Server and Windows 95 ,i have TCP/IP and Named Pipes,but its saying server cannot be found can any one pl help me of what i should do...??? Thanks
View Replies !
How To Register A Table
I was advised to use a table in addition to the standard aspnet_ tables for keeping extra data and to register it with the rest of the database. However, when I tried to register it, I couldn't even see a database to choose from then received an error. All the tables, including the ones I created, work when I run my VSE 2005 project. If someone can give me some A-B-C guidance, I'd appreciate it.
View Replies !
Register Sql Server
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.
View Replies !
Cannot Register SQL Server
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.
View Replies !
Not Able To Register Server
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.
View Replies !
Register A Server
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.
View Replies !
Can't Register SQL Server In Ent. Mgr.
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.
View Replies !
Register 6.5 Server Under 7.0
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)
View Replies !
REGISTER SERVER
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
View Replies !
DTS PACKAGE Do Not Register
Hi When I distrubuided my application In VB, the dll from DTS PACKAGE , slq server, Do not are registred, why ? I have register each with regsvr32 thank you in advance
View Replies !
How Do You Register A SQL Server With T-SQL Or DOS
Does anyone know if it is possible to register a SQL Server with T-SQL or DOS. I reload my machine on average once a month and everytime I have to re-register all of my SQL boxes. I would like to write a script or batch file that will register all of my SQL Server for me. Please help! Thank you, PJ
View Replies !
Unable To Register
Hi, I am trying to register one server and I get the following message - "Client unable to establish connection Connection OpenCreatefile()" Any advice highly appreciated. Thanks PD
View Replies !
Can Connect But Cant Register
Hi there , hope someone out there can shed some light into this subject , myself im running up the wall with it. I have several pc's all running SQL Server 2000 all connected to the main office through a VPN. We are trying to have merge replication working with our Business Aplication and all the sites on the VPN. While trying to register the remote databases on the Main office server , some of the pc's worked like a charm everything is smooth as silk, but now the problem...... Out of 14 total machines , on 3 of them i have this problem. In 2 of them i can open a ODBC connection to the SQL Server wich works , with Query Analyser i can connect to the servers and query all the DB in them.IF i try to register them in Enterprise Manager i get an Access Denied/Server does not exist message ( Using Alias ) , if i go through IP it registers but the merge replication does not work so im stuck with the Alias????Any clue?(1 of the pc's uses XP Pro the other XP Home) On the other pc i cant simply do anything , nothing will work , no odbc,no query analyser no enterprise manager no nothing. Why????I can see the pc's on the VPN , if i do a \IP i can access them so the VPN is working. Thanks in advance for any help
View Replies !
Can't Register Another SQL Server!
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
View Replies !
Interface Not Register
Hi I'm having trouble burning a cd using windows media player, I ripped one of my cds and i want to make a copy and its not letting me do it. When I press burn, it gives me an error message which says: "INTERFACE NOT REGISTER" and i dont know how to fix it. Can someone help me please!
View Replies !
The SQL Server Cannot Register Different Network.
Hi all, I have a big problem with registering SQL server on different network in our business, there have two different areas that the ip is 192.168.10.x, the other is 192.168.0.x, both 10.x and 0.x are connected by router of cisco and it can ping each other SQL server, Sometimes the one side can register SQL server from SQL server of 10.x of IP, but the other cannot register on from 0.x of IP. does anyone know where i can solve this SQL registering problem.
View Replies !
Unable To Register Sql 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!
View Replies !
Register Local Machine
Hi. I am trying to register my local machine as a server using my machine name. This worked fine in SQL 7.0 but have been unable to do so in SQL 2000. Operating system is NT 4.0. Please advise.. Thanks.
View Replies !
Register Server OLAP
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
View Replies !
Unable To Register Sql 7.0 Server
hi, I am unable to register sql 7.0 server on my machine . I have a win 98 . it does not have a network card . Yes i am truing to install sql 7.0 desktop version on my home PC which is not on any network . I get a illegal operation message whenever i try to register a server . thanks
View Replies !
Save Register That WERE Insert
Hi I have 2 Database ( INFORMIX AND SQL-SERVER), When the INFORMIX fall only work SQL SERVER, but when INFORMIX go back, I want to insert in the INFORMIX only register that were inserting in the SQL SERVER while the INFORMIX was out. For it I want DTS for export register, How I can get only this registers ? thank you in advance
View Replies !
How To Register Repository Com Server
I have created few DTS Repository packages and were able to see them in Enterprise Manager through client workstation. But one day they just dissapeared from client EM. I tried to create and save new Repository package, but error message occurred: The Microsoft Repository COM server has not been registered on this system Do any one know how to register Repository Com server? Thanks in advance.
View Replies !
Register SQL Server Remotely
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 Replies !
Cannot Register With External Access
I've done a lot of digging, and I can't find the solution to this one. I followed Vineet's instructions to get an assembly registered that can call out to Web services; however, when I try to register, I get the following error:
View Replies !
Msxml6.dll Failed To Register?
Hello, I am writing a very small application in VB.Net 2005. I added a reference to Microsoft.SqlServer.ManagedDTS so I can use a SQL Server 2000 DTS package on SQL Server 2005. I have one form with an Import at the top: Imports Microsoft.SqlServer.Dts.Runtime ' needed for the DTS package to run and under a start button I have: Dim oApp As New Application Dim oPkg As New Package oPkg = oApp.LoadPackage(g_DTSx_Directory & "AOC copy Generic1 CSV to AOC_verify_file_1.dtsx", Nothing) Dim oResults As DTSExecResult oResults = oPkg.Execute oPkg = oApp.LoadPackage(g_DTSx_Directory & "AOC copy Generic2 CSV to AOC_verify_file_2.dtsx", Nothing) oResults = oPkg.Execute oPkg = Nothing oApp = Nothing This works fine. The problem I am having is when I run the setup wizard to create a setup. In the build of the setup I get a popup that states: The following files may have dependencies that cannot be determined automatically. Please confirm that all dependencies have been added to the project. C:winntsystem32msxml6.dll Then when I run the setup program I get Module C:Program FilesMyCompanyNameSetupSMOmsxml6.dll failed to register, HRESULT -2147023782. Contact your support personnel, I ran regsvr32 msxml6.dll but that does not help. Any suggestions?
View Replies !
Custom Component Seems To Un-register Itself?
I've run into this a second time now. I'm hoping for some resolution AND guidance for proper build, save, etc. protocols in BIDS. I've coded a custom component, included post-build procedures to add it to the GAC, selected it from the "Choose Items..." menu, and successfully added to a data flow. I've then been able to succesfully debug it. This was all Friday afternoon. I shut down my BIDS session(s) and called it a week. This morning when I open BIDS, I get the following error when I attempt to add it to a data flow task: TITLE: Microsoft Visual Studio------------------------------The component could not be added to the Data Flow task.Could not initialize the component. There is a potential problem in the ProvideComponentProperties method.------------------------------ADDITIONAL INFORMATION:Error at Data Flow Task [DTS.Pipeline]: Component "component "" (16)" could not be created and returned error code 0x80131600. Make sure that the component is registered correctly.------------------------------Exception from HRESULT: 0xC0048021 (Microsoft.SqlServer.DTSPipelineWrap)------------------------------BUTTONS:OK------------------------------ What would explain this? I'm new to VS/BIDS. Am I improperly shutting down my BIDS sessions? Is a save required for my code? Does "Build <component>" not automatically save? Also, when I re-build a component after making a change to it, what do I need to do in my package's Data Flow task? Delete the current component, re-add it, and configure it again? I'm sure there are certain things that require one type of re-initialization vs. others (i.e., making a change to the Design Time code vs. making a change to code within the ProcessInput method.) What can I do to properly register this now? I'm dead in the water and have no idea what to do. Any help's appreciated.
View Replies !
I Am Not Able To Register SSIS Package In To JOB
Hi All Can any one help me out? I have Created one SSIS package. When I am trying to register Package in to Job I am Unable to find Option Under Steps. Which Option I have to select for registring a Package into Job. Here, I describe the options which is comming under my SQL Job-Steps. 1. ActiveX Script 2. Operating System(CmdExec) 3. Replecation Distributor 4. Replecation Merge 5. Replecation Queue Reader 6. Replecation Snapshot 7. Replecation Transaction Log Reader 8. Transact-SQL script (T-SQL) I have Installed SQL 2005 then I have installed Service Pack2 for SQL2005. then I tried to install tools for SQL2005 but it was unable to installed. Is there any extra patch needs to be install for that option? Please Provide me Quick Help. Thanks in Advance.
View Replies !
How Do I Register SQL 2005 Developer
Hello, I have installed the eval version of sql 2005 and have also purchased a license for developer edition. How do I register my eval copy to be the developer edition? Is there a special download for developer edition? Thank you Leo
View Replies !
Register Online Sql Server
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
View Replies !
Can't Register Subcriber In SQL 2005
hi, I am setting up Transactional replication From SQL Server 2005 Server TO SQL Server 7.0 Publisher and Distrubutionj in SQL 2005 Box and Subcriber is SQL Server 7.0 with read only. but I was able to configure Publisher & Distrubutor without problem on SQL Server 2005 Managenet Studio. but when I go to configure Subcriber with Managemnet Studio when I click add server as part of Subcriber wizard I get error saying that it can not register SQL Server 7.00 .. is tehre any what I can Register subcriber with Studio or do I have use only T-sql to register ? Thanks hari
View Replies !
Cannot Register Notification Services
Hi everyone, It's going to drive me crazy. I don't know why I cannot register my notification service. I have got this error: "The performance counter category could not be installed. Category Name: NS$CustomerInterfaceInstance:Vacuumer" Additionnal information: "Cannot create Performance Category 'NS$CustomerInterfaceInstance:Vacuumer' because it already exists. (System)" I tried to delete the notification, close SQL ServerManagement Studio, but I always have the same error. I installed two times these same notifications in other computers and never seen that before. I tried to change the name of my instance because it seems that it doesn't delete something but I've got the same error with my former instance name NS$CustomerInterfaceInstance. I don't understand anything, it's crazy! Please help me, if you had the same problem or if you know how to fix it. Thank you, Aurelie. CableOrganizer.com
View Replies !
Trying To Register New SQL Server - Unable To Connect
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.
View Replies !
Cannot Register Instance Of SQL Server 2000
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 Replies !
Unable To Register A Server - URGENT
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.
View Replies !
HELP: Newbie Install. Can't Register Server.
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
View Replies !
How To Register The Class In Sequel Server?
Hello all, I created a class in Visual Basic, In the class I get a filename as parameter and display its size as a output, and I make it as .dll and I register the .dll in the server. After that I try to register the class in Sequel server by means of the below commands DECLARE @object int DECLARE @hr int DECLARE @property varchar(255) DECLARE @return varchar(255) -- Create an object. EXEC @hr = sp_OACreate 'Xp_Filesize.clsconvert', @object OUT select @hr It gives an output -2147221164, it means that the class is not registered in Sequel Server. I dont know How to register the class in Sequel Server? If anyone knows help me to resolve the problem. Thanks. and my procedure is create procedure x(@filename varchar(100)) as begin DECLARE @object int DECLARE @hr int DECLARE @property varchar(255) DECLARE @return varchar(255) -- Create an object. EXEC @hr = sp_OACreate 'Xp_Filesize.clsconvert', @object OUT select @hr IF @hr <> 0 BEGIN EXEC sp_displayoaerrorinfo @object, @hr RETURN END -- Set a property. EXEC @hr = sp_displayoaerrorinfo @object, 'FileSize',@filename IF @hr <> 0 BEGIN EXEC sp_displayoaerrorinfo @object, @hr RETURN END -- Get a property using an output parameter. EXEC @hr = sp_displayoaerrorinfo @object, 'FileSize',@property IF @hr <> 0 BEGIN EXEC sp_displayoaerrorinfo @object, @hr RETURN END PRINT @property -- Get a property using a result set. EXEC @hr = sp_displayoaerrorinfo @object, 'filesize' IF @hr <> 0 BEGIN EXEC sp_displayoaerrorinfo @object, @hr RETURN END end
View Replies !
What Ports Are Use To Register Remote SQL Server?
Hi all, I'm trying to connect to a remote SQL server using my SQL 7 Enterprise Manager. This remote SQL server is behind a firewall. I need to specify to the system administrator to open up ports that I will need to connect to the remote SQL server. Can someone tell me what are the ports required besides port 1433, to make sure the server registration is successful? Thank you in advance.
View Replies !
|
TRACKER
