I open up the SQL Server Agent Job window, and I can't see details under the General, Steps, Schedules, or other tabs unless I am running SSMS directly on that server. So much for remote management, eh? Anybody else experiencing this problem? Anybody else notice that jobs may fail to complete correctly without raising any errors or logging any issues? Anybody else remember when, a year ago, SQL Server was a good product? Anybody think Microsoft is listening? Anybody? Buehler? Buehler?
I have one situation. I need to find out the processes which are all in deadlock state. I my figure out that SQL server maintains the process details in sysprocesses table.
Can any one please help me, Whether this is the table which contains deadlock details. If not where are they stored and How to kill that process ?
An application that i wrote (that interacts with SQL Server 2000) is causing deadlocks on the server. i have no direct access to the server, but the user have sent me a server trace.
Having very little experience with SQL Server 2000, all that i learn from the trace is that, well, there is a deadlock, but i had already known that beforehand.
What other useful details can be interpreted from the trace above? How can i obtain information like the specific statement(s) which cause the deadlock, etc?
We've A2k db which we plan to migrate to SQL 7.0 very soon. Though am familiar with upsizing wizard BUT don't know how to configure Access forms, reports etc. to talk to SQL back end tables. So that information entered via Access forms can be stored in sql and reports can be generated using sql tables..
What are the steps in configuring sql server 6.5 to have excellent performance? what are the items that I should think of and based on what condition I can set up the configuration?
Hi All,Here is my questionWhat might you configure on a SQL Server so that a Web server runningon the same machine, with limited memory, will continue to performoptimally?Thank youRaju
I has created a SSIS FTP Task Programatically for Receiving Files. I have written code for Transfering data from FTP to my local machine. it is working fine. i need to log the details of the file transferred like file name, file size it to database table.
can any one help me to solve this...... its very urgent please.....
I have created a linked server using my local SQL2005. The linked server can be seen as a linked server, but the database can not been expanded to see the tables, stored procedures, views, and other details regarding the linked server. The only method that I have found that will allow me to see all the details is to use XP's Remote Desktop Connection to access the database. Has anyone else experienced this problem, if so, how did you resolve it?
We're planning to install a Server 2005 Failover Cluster and I'd like to find more information about licensing, etc. Basic questions:
- What is the best O.S. to run? Win 2003 or the new 2008? And what version (datacenter, enterprise)? - Since I'm going to use 2 machines, will I have to pay for 2 licenses (sql and windows - two lic. each)? Or just 1 license, since just 1 machine will be the active server?
This is for some web applications, so, web environment.
I'm having a problem configuring one of my SQL servers as a distributor. I've done it successfully on another server, so I know that it's nothing procedural and there must be an issue with the way the server is set up. When I click 'finish' on the Configure Publication and Distribution Wizard, I get the following error message:
Enterprise Manager could not configure 'ABEL' as the distributor for 'ABEL'.
Error 20017: Cannot add the remote distributor at this time. Make sure that the local server is configured as a Distribution Publisher at the Distributor.
Can anyone point me in the right direction? I'm fairly new to SQL Server, so feel free to explain things in a condescending manner. ;-)
I have a SQL Server version 7.0 and want to configure IBM DB2 on OS 390 as a linked server on it . I installed DB2 clients on the SQL Server and thru DB2 Connect ,I am able to access the mainframe data using the clients . However I am having problems configuting the Mainframe server using IBM DB2 OLE DB Driver .I am not sure if we need to use Microsoft OLE DB Driver .
Our company is going to use SAN (HP or EMC or Fuji) for SQL Server failover rather than MSCS. So far, DBA has no knowledge of SAN.
Would you please to tell me, how does SAN depend on SQL Server? I assume SAN software can make disk failover if there is a network, disk or OS failure in primary node. If SQL Server or SQL Agent is failure, can SAN software detect it? (or can SAN disk failover depend on SQL Server or SQL Agent services?)
Please let me know where can I find any configuration document regarding SAN for SQL Server failure. I had spent 2 days in HP and EMC wrbsite and found nothing.
hi there! i have been trin to configure my network for the sql server 6.5 but in vain.Actually i have two pc in the network , one is server and the other is workstation.i install SQL server on the NT server and then install the sql client oon the workstation but i donno how to configure that client for the server. so i just want u leet me that what particular steps should i follow to make that network work properly for the sql server 6.5. i just wanna use sql server 6.5 in a simple situation. i am not an advance user of the sql server 6.5. i will be greatful to GOD if uu help in this problem. sincerely, romanafroz@hotmail.com
Server: Msg 18030, Level 16, State 1, Line 0 xp_sendmail: Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client.
How to configure Outlook and SQL Server Email next?
Hi, I have installed MS SQL Server on a win XP and a MS SQL Server client on a win2000. I don’t know how to configure this client to access the server remotely. Any pointer? Thanks. I am very new to SQL Server.
Hi All, I am new to SQL server 2005. I have installed SQL server 2005 which came along with the visual studio 2005 package. Now i could see the visual studio 2005 in the installed programs list. I really dont know how to configure the the installed SQL server. how to create tables and veiw. frankly speaking i could not see where is the head and tail.
To be straight forward, i havent used any database to a great extent. earlier during the starting of my career, i developed a small application using VC++, which used to interact with the DB server on a very minor scale; whenever i wanted to create a table for used to do it with sql client which was also installed in my machine.
currently i am againg devoloping a small apliccation using VC++, this time for devlopment and testing purposes, I have SQL server 2005 installed in the same machine which i am using for development. Now as i said eralier i am not even aware how to configure, how to start creating table...... :-(
all i have done is i have installed SQL server 2005 and all i could see is SQL Server 2005 listed in the installed programs list :-( some one please help me.... :-(
When I opened "Reporting Service Configuration Manger" from SQL server configuration tool list, The "Report Server Installation Instance window came out. It showed my local machine name on the field of Machine Name. When I click "Find" button, a message box came out. It says: "No report server were found on the specified machine. Details: Invalid namespace
I'm having problem with initialization tab on Configure Report Server
All tabs are checked and green , but when I click initialize I got this error:
ReportServicesConfigUI.WMIProvider.WMIProviderException: The report server installation is not initialized. (rsReportServerNotActivated) at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo) at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.InitializeReportServer(String installationId)
I am trying to get started with Reporting Services, and I am trying to configure the report server on my local computer running vista and sql server 2005.
I am trying to configure according to the following instructions:
But I got stuck on the step 11 to 13, I get the following error when I click on Apply (STEP 13)
ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 800708AC
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool)
do I need to create a user for the reporting services or can I use my own user, which has admin rights on my laptop? Do I need to to do anything before I follow the instruction from http://msdn2.microsoft.com/en-us/library/aa545752.aspx ?
I also need to know how to delete the dabatases I ended up creating using Reporting Services Configuration Manager.
I have came across a table in SQL server 2000 which named 'Order Details' in the sample 'Northwind' database which is available with the product. Am using the eval version . Generally no table name exist with a 'space' between the words. But the table 'Order Details' exist in the Northwind sample database.
Due to the naming convention i can't run sql queries on that. Is anyone aware of this type of issues.
We have a licensed version of VS2005 and we are developing commercial C#.net mobile applications targeted for Pocket PC 2003, Windows CE etc.
We are currently making use of System.Data.SqlServerCe.dll and are using the Sql Server CE for storing and retrieving information required for the application. We use this information and send it to our hosted web server for processing.
We use NSIS installer to develop the installer for mobile application. Can we make use of the Sql Server CE CAB files (sqlce30.dev.ENU.ppc.wce4.armv4.CAB) to install or should we only use the Sql Server CE dlls that are mentioned in the REDIST.txt?
We would like to know if we would be in agreement with the EULA if we make use of the CAB files for installation instead of the direct dlls.
I installed Micrsoft Server Desktop Engine from the CD I received in my ASP.net book. The installation went fine and then I went to the DOS prompt and did the "setup SAPWD..." and it ran. I restarted my computer and opened ASP Matrix and went to the Data tab and proceed to connect to the server. It gave me an error message it couldn't connect.
So I uninstalled MSDE and made sure the sql2ksp3 folder was gone. So I went ahead and installed the MSDE again from the CD again and then went to DOS to do the setup. It ran through the setup until the very end with 11 seconds remaining and received error message " Setup failed to configure the server. Refer to the server error logs and setup logs for more information. I have tried it several times and it always stops around 11 seconds. I have tried to install the download from microsoft.com instead the CD and that didn't work also. So at this point I am stuck. PLEASE HELP!
I also checked my Registry keys for a file called PendingFileRenameOperations and it wasn't in the registry keys.
If anyone has any suggestions I would appreciate it.
I'm having a world of trouble with the Reporting Services Server. The install went fine. I went in to configure the Report Server and when creating the Report Server and the Report Manager virtual directories I get the following error: "The virtual directory could not be created. The previously set virtual directory will still be used." The problem with this is that I have not previously set a virtual directory. When clicking on the link I get the additional error information: "System.IO.FileNotFoundException: at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo) at System.Management.ManagementObject.InvokeMethod(String methodName, ManagementBaseObject inParameters, InvokeMethodOptions options) at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.CreateVirtualDirectory(String virtualDirectory, String path)"
When I check IIS the directories were created but the Reporting Services Configuration Manager does not see them unless I attempt to recreate them again without deleting them from IIS.
could anyone guide me on how to allow, ceate rule for sql server 2005 remote connections to work. i already configured my sql server to allow remote connections and also my router, it is only in isa that is blocking the connections.
While using aspnet_regsql.exe to configure SQL Server for application services, the following error pops up: Failed to query a list of databases names from the SQLserver. Cannot initilaize SSPI package". The page is "Select the Server and Database". Please advise. Thanks.
Hi I am trying to install SQL server 7 on XP. I did not install any prerequisite such as service pack 4. During the installation process, I received a error message that says:
'Setup fail to configure the server. Refer to server errorlog and cnfigsvr.out for more information. '
In Errorlog file, the last part of it says:
. . . SQL server's unicode collation is: 'English' (ID =1033) Comparison style =196609
SQL server's non-unicode sort order is: 'no case_iso'(ID=52)
SQL servers non-Unicode character setn is 'iso_1(ID=1)
I have a question. When my SQL server was originally configured, it was only setup to use named pipes. Now I am needing to setup a P&M server (through Site Server 3.0), but I must have my SQL server to accept tcp/ip network connections. I don't know how to enable named pipes & tcp/ip. Any help would be greatly appreciated.