Installation Hangs When On A Large Network
Sep 14, 2007
Hi All,
I have to do a lot of SQL Server Express 2005 installations and I've noticed that when I'm doing an install on a machine that's on a large network that the installer will "hang" towards the end of the installation process. The installer will say something about Local Groups and sit there for a really long time. As soon as I take the machine off of the network though (via unplugging the network cable) the installer jumps back into action. Of course, I've not seen this on a stand alone machine either...
It would seem to me that the installer is trying to communicate via the network or something and then when it loses its LAN access it just moves on. But I'm not entirely sure why it would need to do that. More importantly, is there a way that I can keep it from doing this? I'm doing a silent install so maybe I can use a command line swith or property?
In reviewing the command line options I didn't see much that seemed to fit; but perhaps one of you folks know of a way to achieve this.
Thank you for anything you can offer.
View 1 Replies
ADVERTISEMENT
Feb 6, 2008
Hi. Does anyone know why a delete statement sometimes hangs when deleting a large amount of data and how to resolve this?
Thanks!
View 2 Replies
View Related
Jul 23, 2005
Hi,Currently it is running on SQL 7.00.623 on Winnt 4.0+SP5.Now i want to upgrade this with SP 4.As i follow the installation procedure according to MicrosoftSQL7SP4 readme help, It hangs during the installation of Mdac_typ.exe.Don't know where and whats went wrong with the procedure.I've tried 3-4 times to install it but the same problem raises. Pleasesome body assist me how to complete this installation.Thanks in advanceIvar
View 2 Replies
View Related
Mar 8, 1999
ISQL.EXE hangs during installation. In task manager, when I end task on ISQL.EXE the installation continues, but msdb comes up suspect. Can someone please help me.
View 2 Replies
View Related
Apr 30, 2007
At stage: Visual Studio Integrated Development Environment 2005
Coping new files dv_commoner.hxs Directory....... 89818
Last lines in SQLSetup0001_ADH1_PPESku_1.log:
........
MSI (s) (40:C8) [10:32:18:640]: Executing op: ChangeMedia(MediaVolumeLabel=SQLDEV,MediaPrompt=Please insert the disk: Microsoft Visual Studio 2005 Premier Partner Edition - ENU Disk 1,MediaCabinet=1\_1519_RTL_x86_enu_VSCC_Help_Collection.cab,BytesPerTick=32768,CopierType=1,,,SignatureRequired=0,,,IsFirstPhysicalMedia=1)
MSI (s) (40:C8) [10:32:18:656]: Executing op: FileCopy(SourceName=92310|dv_commoner.hxs,SourceCabKey=commoner_hxs_8_ENU____.3643236F_FC70_11D3_A536_0090278A1BB8,DestName=dv_commoner.hxs,Attributes=16384,FileSize=89818,PerTick=32768,,VerifyMedia=1,,,,,CheckCRC=0,Version=8.0.50730.10000,Language=1033,InstallMode=58982400,,,,,,,)
MSI (s) (40:C8) [10:32:18:656]: File: C:Program FilesCommon FilesMicrosoft SharedDevHelpVSCCv8.0dv_commoner.hxs; To be installed; Won't patch; No existing file
MSI (s) (40:C8) [10:32:18:656]: Source for file 'commoner_hxs_8_ENU____.3643236F_FC70_11D3_A536_0090278A1BB8' is compressed
Please help with problem and how to procceed.
Thanks
ADH
View 2 Replies
View Related
May 31, 2006
I am trying to install SQL 2005 SP1 on a Windows 2000 Server SP4 platform. I have repeatedly tried this, and have trashed and re-built the platform all to no avail. I keep getting the same problem. The installation hangs, using 0 CPU apparently after successfully extracting the files to disk. It leaves the HOTFIX.EXE running, and cancelling it ends the process. The HOTFIX.LOG looks like this:
5/31/2006 10:05:03.185 ================================================================================
05/31/2006 10:05:03.185 Hotfix package launched
05/31/2006 10:05:03.195 Successfully opened registry key: SOFTWAREMicrosoftWindowsCurrentVersion
05/31/2006 10:05:03.195 Successfully read registry key: CommonFilesDir, string value = G:Program FilesCommon Files
05/31/2006 10:05:03.195 Successfully opened registry key: SOFTWAREMicrosoftWindowsCurrentVersion
05/31/2006 10:05:03.205 Successfully read registry key: ProgramFilesDir, string value = G:Program Files
I have been searching various forums for an answer and have found one hit here (but no answer):
http://www.eggheadcafe.com/aspnet_answers/SQLServersetup/May2006/post26789173.asp
After reading this I cancelled the CMD.EXE instead of the HOTFIX.EXE and duly got a "Product Enumeration" popup window. The HOTFIX.LOG now looks like this:
05/31/2006 12:27:18.057 ================================================================================
05/31/2006 12:27:18.057 Hotfix package launched
05/31/2006 12:27:18.057 Successfully opened registry key: SOFTWAREMicrosoftWindowsCurrentVersion
05/31/2006 12:27:18.057 Successfully read registry key: CommonFilesDir, string value = G:Program FilesCommon Files
05/31/2006 12:27:18.067 Successfully opened registry key: SOFTWAREMicrosoftWindowsCurrentVersion
05/31/2006 12:27:18.067 Successfully read registry key: ProgramFilesDir, string value = G:Program Files
05/31/2006 16:09:34.452 Successfully opened registry key: SOFTWAREMicrosoftWindowsCurrentVersion
05/31/2006 16:09:34.462 Successfully read registry key: CommonFilesDir, string value = G:Program FilesCommon Files
05/31/2006 16:09:34.462 Successfully opened registry key: SOFTWAREMicrosoftWindowsCurrentVersion
05/31/2006 16:09:34.462 Successfully read registry key: ProgramFilesDir, string value = G:Program Files
05/31/2006 16:09:34.462 Local Computer:
05/31/2006 16:09:34.462 Target Details: PET005-5
05/31/2006 16:09:34.462 commonfilesdir = G:Program FilesCommon Files
05/31/2006 16:09:34.462 lcidsupportdir = G:sql2005sp1_ext1033
05/31/2006 16:09:34.472 programfilesdir = G:Program Files
05/31/2006 16:09:34.472 supportdir = G:sql2005sp1_ext
05/31/2006 16:09:34.472 supportdirlocal = G:sql2005sp1_ext
05/31/2006 16:09:34.472 windir = G:WINNT
05/31/2006 16:09:34.472 winsysdir = G:WINNTsystem32
05/31/2006 16:09:34.472
05/31/2006 16:09:34.512 Enumerating applicable products for this patch
05/31/2006 16:09:34.532 Found Redist 2005 product definition
And there is also now a REDIST9_HOTFIX_KB913090.LOG file which looks like this:
05/31/2006 16:09:34.582 ================================================================================
05/31/2006 16:09:34.582 Hotfix package launched
Yes I am logged on as an Administrator. Yes the SQL 2005 is off the latest MSDN CDs.
How do I resolve this issue and install SP1?
View 8 Replies
View Related
Sep 14, 2005
When i will try to install SQL Server Express Manager in W2K SP4, its fail with error in Event Viewer:
View 1 Replies
View Related
Feb 16, 2007
I just bought a new laptop with Vista pre-installed and was able to install Visual Studio 2005 Pro, but when attempting to install SQL Server 2005 it just hangs at the IIS detection step. I was using the administrative account. I was able to install the Developer Edition of SQL Server 2000, but I need 2005.
Some posts mention IIS version issues and 32 vs 64 bit version issues. Can anyone ellaborate on what is happening and why? What is the work around?
View 6 Replies
View Related
May 9, 2006
After the installer has asked for authentication mode and has started verifying the authentication it simply hangs. I've let it sit there for an hour before taking the installer forcibly down but nothing seems to be happening except for two osql.exe processes showing up in the task manager.
I've tried both windows authentication and SQL server authentication but the outcome is always the same. At the same time I'm, however, able to login to the database engine and all services with management studio using both authentication modes.
The last few lines in HotFix.log are as follows:
05/09/2006 09:49:09.999 Authenticating user using Windows Authentication
05/09/2006 09:49:10.015 SQL Service MSSQLServer was previously running, ready for authentication
05/09/2006 09:49:10.218 SQL Agent Service SQLSERVERAGENT was previously running
05/09/2006 09:49:12.093 User authentication was successful
This would indicate that there's nothing wrong with the authentication but with whatever is supposed to take place after that.
There are quite a few lines in the log similar to the one below:
05/09/2006 09:47:08.438 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.2MSSQLBinnSQLServr.exe
Redist9_Hotfix_KB913090.log seems to be the only individual log file that ends with line saying "Hotfix package launched" whereas all other logs have several lines of checks being completed successfully.
Any ideas what might be causing the installer to hang and how to fix it?
View 4 Replies
View Related
May 16, 2008
During installation of MSDE the installation hangs at "please wait while Windows configures microsoft sql server desktop engine" I always end up killing the installation process. I am trying to install Windows XPe dev kit and this is the step I am getting stuck on. If I try to skip this step and setup the database the setup obviously tells me that i dont have sql 200 or MSDE installed.
The KB article http://support.microsoft.com/kb/811479 describes the syptoms perfectly, but fast user switching isnt even enabled for this machine and is not the source of the problem.
View 8 Replies
View Related
Feb 2, 2007
I have a virtual machine that previously had SQL Server 2005 installed. Since I changed the computer name, I have to reinstall SQL. I removed all the SQL components and am trying to reinstall the database and reporting components. The installation is failing on the "Removing temporary files" step. According to the setup progress screen, the following components have been installed:
OWC11
SQL Server Bakcward-Compatibility Files
SQL Server Database Services
Reporting Services
Visual Studio Integrated Development
SQL Server Books Online
SQLXML4
Workstation Components, Books Online - this step is still in "configuring components" status.
The virtual machine is running Windows 2003 Server SP1 with all current patches, using just under 2 GB of memory (1920 MB of RAM), the host is Windows XP SP2 with all current patches, with 4 GB of memory.
I had no problem doing this procedure on a different virtual machine, so I'm not sure what the problem is here.
View 2 Replies
View Related
May 22, 2007
Does anyone know of the procedure, steps that need to be followed to allow installing SQL 2005 Express from a network? Since SQL 2005 express requires .NET 2 and the MSI engine 3.1 and MDAC 2.8 it is a real problem pushing it from a network such as active directory using an AIP (Administrator Installation Point).
View 3 Replies
View Related
May 16, 2008
Hi,
This is a very bizzare one. I have installed SQL many times and never had this problem. I had a user self install SQL 2005, as it turns out, he installed the wrong components, so a co-worker uninstalled it for him. We followed the support doc for the uninstall, because we had errors when tried to remove it.
http://support.microsoft.com/kb/909967
After, we were able to re-install (we installed this time via the command line), but for some odd reason we have completely lost the ability to print to ANY network printer. I didn't think this was possible, but I tried it on my machine and now I too am unable to print!
A couple of details:
Both machines:
XP-SP2
HP dx7400
Printers: a variety of HP Networked Printers (can't print to any)
I have added and removed the printers multiple times and tried adding via a local port... no luck
There is no error in the event log
If I try to print a test page, I get an error box that says "Test Page Failed to Print"
Since there are no real errors for the print issue, I am struggling to find a solution. Has anyone ever seen this??
Thanks!
Dria
View 1 Replies
View Related
Sep 30, 2004
Hello all,
We have a Windows 2003 Web Edition server serving a site through IIS. It connects to a Windows 2003 Standard Edition server running SQL 2000 SP3a.
This site receives the following error as seen in the topic:
[DBNETLIB][ConnectionRead (recv()).]General network error. Check your network documentation.
We've configured the server network utility to only allow TCP/IP connections. The connection string for the site is as follows:
<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
MM_connSpankMSSQL_STRING = "Provider=sqloledb;Data Source=SERVER_IP,1433;Network Library=DBMSSOCN;Initial Catalog=ourmaindb_1;User ID=ourmaindb_1;Password=hotcookies;"
%>
Any ideas or tips on solving this issue? We've noticed it is due to larger queries as smaller ones do work with no problems.
The servers are behind a BSD box running iptables, has 1433,1434 along with standard web ports wide open. Anything outbound is allowed.
Some further testing via ODBC on the IIS server improved things. No more connection pooling for the SQL Server driver allows for 1/3 of the query to run. Still 2/3s of it doesn't show up, and that general network error message appears.
Should have 330 rows if it works right.
View 2 Replies
View Related
May 19, 2004
Hi
While running a DTS, many times the error message: "[DBNETLIB][ConnetionWrite (WrapperWrite()).]General network error. Check your network documentation." appears.
Does somebody knows why?
I am running the DTS from a computer (not the server where the DTS is stored) and it is connected without any problem when this happens.
Thanks!!
Regards
Lautaro - Argentina.
View 4 Replies
View Related
Oct 4, 2007
Hi Every one,
I am using .Net 1.1 for my web application.
And my database server is SQL Server 2005.
My application is running fine, as i can login to it and also able to view pages. But when i open Order management(having 3K records) its give me error,
General Network Error. Check your network documentation
I have also searched many articles and tried following solutions but nothing working
- connectiontimeout = 0, max pool size = 7500/100, pooling = false
- SSL disabling enforce security false as mentioned in microsoft kb article.
And there's nothing any issue with hardware/firewall as my application's login and other forms are working fine(which use same database with same connection string)
Can any one please help me to solve this error?
With Regards,
View 3 Replies
View Related
May 26, 2007
Hi We have a written a error log in Global.asax. which capture below mentioned error in the prodcution server. Same applications is working fine in some locations and some loactions we are getting the error.Any body knows why this error is occurs.Any body knows why this error is occurs. Error Message:General network error. Check your network documentation.Stack Trace: at System.Data.SqlClient.SqlInternalConnection.OpenAndLogin() at System.Data.SqlClient.SqlInternalConnection..ctor(SqlConnection connection, SqlConnectionString connectionOptions) at System.Data.SqlClient.SqlConnection.Open() at datalayer.sqldb.Execute(String ProcedureName, SqlParameter[] Parameters) at lms.User.GetUserDetails(String strUserid)ITs at LMS.Login.w_btn_Login_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
View 2 Replies
View Related
Oct 4, 2007
Hi,I am using .Net 1.1 for my web application.And my database server is SQL Server 2005. My application is running fine, as i can login to it and also able to view pages. But when i open Order management(having 3K records) its give me error,General Network Error. Check your network documentation I have also searched many articles and tried following solutions but nothing working- connectiontimeout = 0, max pool size = 7500/100, pooling = false- SSL disabling enforce security false as mentioned in microsoft kb article. And there's nothing any issue with hardware/firewall as my application's login and other forms are working fine(which use same database with same connection string) Can any one please help me to solve this error?
View 2 Replies
View Related
Feb 8, 2004
When I try to update the site setting, I get this Error and I don't know how to fix.
Server Error in '/DotNetNuke' Application.
--------------------------------------------------------------------------------
General network error. Check your network documentation.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: General network error. Check your network documentation.
Source Error:
Line 281:
Line 282: myConnection.Open()
Line 283: myCommand.ExecuteNonQuery()
Line 284: myConnection.Close()
Line 285: End Sub
Source File: C:DotNetNukeComponentsAdminDB.vb Line: 283
Stack Trace:
[SqlException: General network error. Check your network documentation.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +721
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +196
DotNetNuke.AdminDB.UpdatePortalInfo(Int32 PortalId, String PortalName, String PortalAlias, String LogoFile, String FooterText, Int32 UserRegistration, Int32 BannerAdvertising, String Currency, Int32 AdministratorId, String ExpiryDate, Double HostFee, Double HostSpace, String PaymentProcessor, String ProcessorUserId, String ProcessorPassword, String Description, String KeyWords, String BackgroundFile, Int32 SiteLogHistory) in C:DotNetNukeComponentsAdminDB.vb:283
DotNetNuke.SiteSettings.Update_Click(Object sender, EventArgs e) in C:DotNetNukeadminPortalSiteSettings.ascx.vb:287
System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e)
System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
System.Web.UI.Page.ProcessRequestMain()
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
Please Help!
Thank you,
dlouanis
View 2 Replies
View Related
Jan 9, 2006
I use sqlclient to connect directly from my mobile 5 pocketpc to a sql server 2005 database on my desktop.
I use a sqldatareader to traverse the results of a query that delivers 2 fields: (1) the filespec, and (2) the image field.
I use a filestream with a binary writer to write the contents of the image data to the pocketpc's storage card.
I have a test table with 10 images, not one more than 4 MB. I cannot complete a test run prior to receiving the general network error.
The pocketPC is connected via activesync to the desktop, and I connect to the database with:
Integrated Security=false;
user id=sa
password=admin.
Any help with this strange error would be greatly appreciated.
Wil
View 5 Replies
View Related
Oct 11, 2006
Hi I get a "General Network Error Check network documentation" error sometimes, but its only while insert or update statements are fired while selects keep working perfectly.
The Error details are as follows:
General network error. Check your network documentation.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: General network error. Check your network documentation.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException: General network error. Check your network documentation.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
View 1 Replies
View Related
Aug 16, 2005
Hi,I am getting the following error (When i am trying to update the column thru windows service) Please let me know the solution for the following.The following error is comming only when i set CommandTimeout to infinity (Commandtimeout=0).General network error. Check your network documentation. Number 11 Procedure ConnectionRead (recv()). Class 20 State 0 Source .Net SqlClient Data Provider Server Line number 0 Thanks and Best RegardsNagaraju A
View 2 Replies
View Related
Mar 9, 2013
The 6:th of march Sql server data tools for Visual Studio 2012 was released.
[URL]
I seem to be unable to install this using the link provided on the blog page. I'm getting a "Same architecture installation" error. Running on the machine is Visual Studio 2012 Premium & Sql Server 2012 (64bit).
why I'm getting this installation error.
View 14 Replies
View Related
Oct 2, 2005
I am trying to install SQL Server 2000 on a Win2K OS machine but Iget this error message:"A previous program installation created pending file operations onthe installation machine. You must restart the computer before runningsetup."I see others have had this problem but have fixed it using the solutionin:http://support.microsoft.com/defaul...kb;en-us;312995I have tried the solution but to no avail. The registry key:HKEY_LOCAL_MACHINESYSTEMCurrentControlSetContro lSessionManagerPendingFileRenameOperations keeps reappearing as soon as Iclose RegEdit.Any ideas?Thanks,lq
View 3 Replies
View Related
Jul 23, 2005
Please help,I am trying to install MSDE 2000 so that Backup exec will run on thisserver. I have gotten so far as to find an entry in my SQLSTP.TXT filethat says that c:mssql7 was detected so the install fails.Now, to start with there is no directory called C:mssql7 on thisserver. I have gone through all MS articles on manual removal of SQLserver and instances. I have searched the registry for mssql7 andremoved any keys that matched, as per MS article I have searched onSQLBOOT.dll and it is not present anywhere on my system and I still getthe same results.2:07:44 Begin Action: Detection12:07:44 SQL Server version already installed: 7.00.62312:07:44 Previous Install SQL Path: C:MSSQL712:07:44 Previous Install SQL Data Path: C:MSSQL712:07:44 End Action Detection12:07:44 Begin Action: ODBCLocked12:07:44 End Action ODBCLocked12:07:44 GetDefinition returned: 112:07:44 Previous SQL Server ProductType: MSDE [0x4]12:07:44 This combination of Package and Operating System allows a fullproduct install.can anyone think of anything here..what else could be causing the server to think there is a previousversion of SQL 7 on this box!!!?
View 1 Replies
View Related
May 3, 2006
I get an error when trying to install the SQL Native Client. It
says it cannot find the installation package and to use a valid copy of
'sqlncli.msi'. I've downloaded the Express setup twice and get
the same error from both of them.
I'm attempting this in a VMWare session setup for Windows 2K, Advanced
Server. I am trying to test my installation and setup
procedures. This is not a production setup, just install testing
and documentation. I have allocated only 272MB to the VMWare
session, which is why the system doesn't meet the recommended settings.
Any help would be greatly appreciated.
Below is the Summary.txt output file.
Microsoft SQL Server 2005 9.00.2047.00
==============================
OS Version : Microsoft Windows 2000 Advanced Server Service Pack 4 (Build 2195)
Time : Wed May 03 09:54:23 2006
CPCWIN2KVM1 : The current system does not meet recommended hardware
requirements for this SQL Server release. For detailed hardware
requirements, see the readme file or SQL Server Books Online.
Machine : CPCWIN2KVM1
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.2047.00
Install : Successful
Log File : c:Program
FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0003_CPCWIN2KVM1_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : CPCWIN2KVM1
Product : SQL Native Client
Error : An
installation package for the product Microsoft SQL Server Native Client
cannot be found. Try the installation again using a valid copy of the
installation package 'sqlncli.msi'.
--------------------------------------------------------------------------------
Machine : CPCWIN2KVM1
Product : Microsoft SQL Server Native Client
Product Version : 9.00.2047.00
Install : Failed
Log File : c:Program
FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0003_CPCWIN2KVM1_SQLNCLI_1.log
Last Action : InstallFinalize
Error String : An installation package for the
product Microsoft SQL Server Native Client cannot be found. Try the
installation again using a valid copy of the installation package
'sqlncli.msi'.
Error Number : 1706
--------------------------------------------------------------------------------
Machine : CPCWIN2KVM1
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.2047.00
Install : Successful
Log File : c:Program
FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0003_CPCWIN2KVM1_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine : CPCWIN2KVM1
Product : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install : Successful
Log File : c:Program
FilesMicrosoft SQL Server90Setup
BootstrapLOGFilesSQLSetup0003_CPCWIN2KVM1_MSXML6_1.log
--------------------------------------------------------------------------------
View 4 Replies
View Related
Jul 28, 2007
Hi all,
What is client network and server network alias in SQL server.
when and why we should use that mean what is the requirement of ALIAS in SQL Server.
Thanks
View 5 Replies
View Related
Oct 2, 2006
Hi every one,
I'd like to install SQL SERVER 2005 Express Edition ,I begin to install it from DVD but during the installation it dosn't ask me about any instance and after installation there isn't SQLExpress service and I can't use sql server .(there are not MSSQL and Binn directory in sql server 2005) but when I install visual studio 2005 and after that I install sql server 2005 it ask me for name of instance and with this way every thing is ok and I use sql server completely.
I 'd like to know the complete installation of sql server 2005 is depend on installation of visual studio 2005 befor it ?if not how can I introduce any instance after installation of sel server 2005 .
View 11 Replies
View Related
Jun 26, 2001
I posted a message about this yesterday but I have more info..
I have a server (SQL 7.0, sp2) that anywhere I connect to it through EM the EM hangs. I can drill down into the server and even get into the Security drop down but if I hit Databases to drill down or Management etc. It hangs.
I did profiler on this and another server. When I click the + by the Database folder I hang and get
"TSQL:Batch Starting: exec sp_MSdbuseraccess N'db', N'%'"
but never get a "TSQL:BatchCompleted" for that statement. (Where other working servers I do get the set of both start and completed)
Drilling into the Security tab runs the query: exec sp_MSDBUserpriv... etc.) and this one works..
Anyone have any info on: exec sp_MSdbuseraccess N'db', N'%'
I can't find anything in BOL, Microsoft KB, Technet etc.. Please Help as there are certain things I can't do without EM... THANKS!!!
View 1 Replies
View Related
Jun 5, 2001
I have been trying all day to install SQL 7.0 on an NT 4.0 SP6a server. It gets to the point where it wants to load MDAC and just goes out to lunch. No errors are generated and the rest of the system does not appear to be affected. However, the only way to end the install is to end task it. Has anyone run into this?
View 1 Replies
View Related
Sep 28, 2001
Some of my jobs hang at FTP step for several hours until some one kills the FTP (it's a perl process) on the box. Is there a way to find how much time a particular step of the job is executing? and know it by somehow if it's hanging at that step?? If we know this,I want to kill the perl process(FTP) on the box in an automated way whenever the job hangs! Any ideas welcome!! Thanks. :-)
Di
View 3 Replies
View Related
Oct 25, 2000
Hi all - I'm having a problem with a dts job that I haven't run across before. The function of the job itself is pretty basic just moving data into a sql table using a few lookups and mappings. The job starts fine and gets to a status of 5000 records processed and just sits there. It's doesn't go into a 'not responding state' nor does it produce any error information in the error file I set up. Anyone have any thoughts on what might be happening? How to identify the specific record it may be hanging on? Help!! - this one is driving me nuts.
View 4 Replies
View Related
Dec 4, 2000
I'm running a pretty simply DTS just to pump some data into a table. Nothing fancy just a couple lookups and a couple columns being copied over. I get to 5000 records processed and the DTS just spins its wheels. It does not go into a 'not responding' state. There are no indexes on the table and the db size is plenty big so it is not reindexing or resizing the db at this point. Any ideas on how I can debug this one would be greatly appreciated.
Thanks
View 2 Replies
View Related
