SQL Server 2005 SP1 Installation Hangs At Authentication Verification
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
ADVERTISEMENT
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
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
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
Jun 19, 2007
Hello
I Just installed Reporting Services 2005 and I have a problem to make work
After installing it and setting different properties in the Reporting Services Configuration Manager, When it comes to verifying the installation, http://localhost/ReportServer or http://localhost/Reports pops up a Login Window, Where I enter Windows Account Username/Password, but this windows pops up again 3 times then I get Error page with the message:
HTTP 401.1 - Unauthorized: Logon Failed
Internet Information Services
SQL Server 2005 with SP2 is installed on WinXP SP2
What could be the reason?
View 3 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
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
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
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
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
View Related
Apr 2, 2007
Hello,
I am having a problem with SQL Server (Express) hanging during simple debugging of CLR code. I created a test project with a user defined function, and call this from the test script. The output log shows that the sqlservr.exe was auto-attached successfully, and then the everything hangs. I have to terminate debugging in order to regain control, and this takes perhaps a minute or two.
Any ideas?
View 11 Replies
View Related
Aug 10, 2007
Just purchased a new server, and am trying to install SQL Server 2005 standard, 64 bit. I'm running Windows Server 2005 r2 64 bit.
Setup support files installs fine.
System configuration passes all 14 checks.
Then it moves to install and just hangs there. Eventually, perhaps maybe after 20-30 minutes does it create a message saying that the Install has failed to respond. Retry or cancel.
View 3 Replies
View Related
Apr 9, 2007
Hi
I got an access 2002 application front end with a sql server 2005 express back end. Some of my clients are having some difficulties. After using the application for a while, some of the users are finding that the system just hangs up. It usually happens after the front end application has been running for about an hour (sometimes sooner and sometimes later). There are perhaps 1 to 5 concurrent users and I have checked to see if there are any firewalls stalling it (I think I check all of them)- Is there any way that SQL Server 2005 express could be caused to just stall- This even occurs with the odd laptop. All the appropriate protocols are enabled as well. These databses are not very large.
ANY HELP WOULD BE GREATLY APPRETIATED!!!
Thanks
Frank Srebot
View 4 Replies
View Related
Oct 19, 2006
I am experiencing extremely slow behavior (no activity for > 30 mins) during a SS 2005 Dev Edition install on XP SP2 on various steps during the SQL Server Database Services step - e.g. during "Setting File Security". This is very annoying.
I've found many postings on this issue indicating that OS calls in this part of the install (e.g. LookupAccountName()) are network speed dependent.
Does Microsoft have any plans to rework this part of the install to rid the need of these calls? I really wish the install would be possible without these calls - it's driving me crazy monitoring this for hours. We've got to roll SS2005 out to a couple hundred developers eventually and this isn't going to cut it.
Thanks for your time on this matter.
Best Regards,
Mike
View 5 Replies
View Related
Aug 22, 2007
I folks.I Have installed sql server 2005 express and choosed windowsauthentication on instalation, but i make a mistake and now i needmixed authentication, how can i modify this whithout uninstall andinstall again the application?thanks for the help.
View 2 Replies
View Related
Feb 10, 2006
i m using the hands-on labs for SQL server 2005.
Step 6 age 14 i went thro and it make my SQL server 2005 hangs when i try to use the flat file destination.
View 1 Replies
View Related
Aug 15, 2007
I have two tables
t_DTM_DATA_STAGING around 2 million records
t_DTM_DATA around 251 million records
The below SQL statement looks for records in the t_DTM_DATA_STAGING table that are not in the t_DTM_DATA table and adds them to a 3rd table. (t_DTM_DATA_STAGING2)
This statement has been running fine for weeks, but now it seems to get hung every day. I ran sp_Who2 and it says the status is runnable. I let it run for around 5 or 6 hours the other day to see if it will finish but it didn't. This SQL job is step 3 in a 6 step SQLAgent job that usually finishes in 30 to 45 minutes.
I'm not sure how to troubleshoot this problem. No other jobs are running at the time this job runs.
Could this SQL statement be written a better way?
Thanks for any help anyone can provide.
Jerid
SET QUOTED_IDENTIFIER ON
INSERT INTO
[DTM].[dbo].[t_DTM_DATA_STAGING2]
([CP],,[MAJ],[MINR],[LOCN],[DPT],[YEAR],[PD],[WK],[TRDT],[SYSTEM],[AMOUNT],[DESCRIPTION],[GROUP],[VENDOR]
,[INVOICE],[IDAT],[PO_NUMBER],[DDAT],[RCV#],[RDAT],[RSP],[EXPLANATION],[UPLOAD_DATE],[UPLOAD_USER],[UPLOAD_NAME]
,[RELEASE_DATE],[RELEASE_USER],[RELEASE_NAME],[TRTM])
SELECT
t_DTM_DATA_STAGING.CP, t_DTM_DATA_STAGING.CO, t_DTM_DATA_STAGING.MAJ, t_DTM_DATA_STAGING.MINR, t_DTM_DATA_STAGING.LOCN, t_DTM_DATA_STAGING.DPT,
t_DTM_DATA_STAGING.YEAR, t_DTM_DATA_STAGING.PD, t_DTM_DATA_STAGING.WK, t_DTM_DATA_STAGING.TRDT, t_DTM_DATA_STAGING.SYSTEM, t_DTM_DATA_STAGING.AMOUNT,
t_DTM_DATA_STAGING.DESCRIPTION, t_DTM_DATA_STAGING.[GROUP], t_DTM_DATA_STAGING.VENDOR, t_DTM_DATA_STAGING.INVOICE, t_DTM_DATA_STAGING.IDAT,
t_DTM_DATA_STAGING.PO_NUMBER, t_DTM_DATA_STAGING.DDAT, t_DTM_DATA_STAGING.RCV#, t_DTM_DATA_STAGING.RDAT, t_DTM_DATA_STAGING.RSP,
t_DTM_DATA_STAGING.EXPLANATION, t_DTM_DATA_STAGING.UPLOAD_DATE, t_DTM_DATA_STAGING.UPLOAD_USER, t_DTM_DATA_STAGING.UPLOAD_NAME,
t_DTM_DATA_STAGING.RELEASE_DATE, t_DTM_DATA_STAGING.RELEASE_USER, t_DTM_DATA_STAGING.RELEASE_NAME, t_DTM_DATA_STAGING.TRTM
FROM
t_DTM_DATA_STAGING
LEFT OUTER JOIN
t_DTM_DATA AS t_DTM_DATA_1
ON
t_DTM_DATA_STAGING.TRTM = t_DTM_DATA_1.TRTM
AND
t_DTM_DATA_STAGING.TRDT = t_DTM_DATA_1.TRDT
AND
t_DTM_DATA_STAGING.PD = t_DTM_DATA_1.PD
AND
t_DTM_DATA_STAGING.YEAR = t_DTM_DATA_1.YEAR
AND
t_DTM_DATA_STAGING.DPT = t_DTM_DATA_1.DPT
AND
t_DTM_DATA_STAGING.LOCN = t_DTM_DATA_1.LOCN
AND
t_DTM_DATA_STAGING.MINR = t_DTM_DATA_1.MINR
AND
t_DTM_DATA_STAGING.MAJ = t_DTM_DATA_1.MAJ
AND
t_DTM_DATA_STAGING.CO = t_DTM_DATA_1.CO
AND
t_DTM_DATA_STAGING.CP = t_DTM_DATA_1.CP
WHERE
(t_DTM_DATA_1.CP IS NULL)
View 4 Replies
View Related
Dec 10, 2003
I have a very interesting problem. I am unable to access ANY SQL Server databases from my installation of VS .NET. This happens in the designer (i.e. Configure SqlDataAdapter), in code, and in Server Explorer. In all cases, I get a connection failed message. I am 100% sure that I am using a valid username/password, and I am attempting to connect using SQL Server Authentication. All the SQL Client tools connect 100% of the time to my local and remote databases.
I have verified that I can access these databases correctly from another machine where VS .NET is installed.
At this point, I am at a loss for how to proceed. I suspect that there is a problem with my MDAC components, but I cannot figure out how to fix it.
Any help would be greatly appreciated!
View 1 Replies
View Related
Sep 29, 2007
Hi all!
My name is Ivan and I am from Serbia.
I'm sort of newbie in sql server, so don't mind for confusion.
I installed SQL Server 2005 Express edition with Advanced Services. During Setup I have choosen to use Windows authentication for connecting to my server, cause I read it can be removed in SQL Server Management Studio (right-click on server, Properties, Security, SQL Authentication).
Few days ago I got some mdf database to attach to my server, but in readme file in the same folder, there was a message to create new user called 'Bob' (password 'msdn') with dbo permission to that database (with SQL Authentication mode access to server). I did so, created user, went to Server Properties, changed mode for Authentication), disconnect from server, and closed Management Studio. When I opened it again I clicked on SQL Authentication to connect, typed Bob as user name, msdn as password, and I got a message which was something about that it is not possible to connect with SQL Server Authentication mode, although I made a difference in Properties.
Should I install SQL Server with the new instance and with SQL Authentication mode?
Please help me out.
View 4 Replies
View Related
Apr 18, 2008
The setup athenticates the Database Services and the Reporting Services.
Database Services login is successful, but the setup raises an error on the authentication of the reporting Services.
How can I fix this?
View 1 Replies
View Related
Apr 18, 2007
Hi there,I have installed MS SQL Server 2005 on my machine with windows authentication. But now I want to switch the authentication mode to SQL Authentication. I am unable to switch, I can’t find the proper way to do so here in 2005.Could any one help me in doing this?Thank you,-Ahsan
View 1 Replies
View Related
Dec 20, 2007
Is it possible to change authentication mode after sql express has allready been installed?
I have admin rights on the computer and i want to change authentication mode to "sql server and windowns authentications mode".
Is this possible somehow?
Maybe by logging in with a trusted conncection?
I need to do it unattended on several computers after they have been installed.
View 4 Replies
View Related
Oct 6, 2007
HELP!
For the past several weeks, I have been trying to install SQL Server 2005 on a Win XP SP2 PC. Regardless of the options I choose (SQL Engine + Client Tools, Client Tools only, etc.) when the installation gets to the end of the Client Tools setup and the setup status displays "Removing Backup Files", my PC appears to hang.
For a period of time, there is a fair amount of HD activity which gives me the impression that files are in fact being deleted, but then there is no HD activity and the installation appears to hang. Finally I give up and kill the setup process and reboot.
After reboot, it appears that the client tools have been installed (the icons appear and I can open the Management Studio, but when I try to connect to an existing instance of SQL, that hangs. This occurs for either Windows or SQL authentication.
Has anyone experienced this behavior and determined the root cause? What EXACTLY is happening during the "Removing Backup Files" phase of the installation?
Thanks for any help in advance,
Marc Mueller
View 3 Replies
View Related
May 12, 2007
Hello, I am pretty new with SQL Server 2005.
I have installed SQL Server Express Edition. I have migrated a set of tables from Oracl10g (by using Microsoft's Migration Tool Kit).While I am trying the following simple update command, the session hangs and it never finishes !!!!!!!!!!!!
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
select pos_key from pos_station where staff_key = 1105
POS_KEY
=======
NULL
update pos_station set pos_key = 1 where staff_key = 1105
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
The table has a few constraints and a couple of indices in place.
Then I create another table (but no contraints or indices), just copy the data from the problematic one and the update WORKS (in msecs) :
update pos_station_new set pos_key = 1 where staff_key = 1105
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
Is there any way to tell if the table (any table in SQL Server) is corrupted or not ?
How can I tell if a session is waiting for something and what is that something ?
Thank you very much for your help.
Tom
View 7 Replies
View Related
Sep 3, 2007
I installed Visual Studio 2005 Professional then after that was installed and running, I tried to install the the SQL Server 2005 Developer's Edition which installed but I do not get the SQL Server 2005 Studio Manager. I have remove and reinstalled but it never gets installed. Any ideas?
Chuck
View 4 Replies
View Related
Feb 18, 2015
I am thinking about moving some backups from the local machine to a remote server. Right now, I am using Ola Hallengren script for backups. The script performs checksum on the backup while it's being written on the disk. I am going to move the files using Robocopy utility. How do I check the data integrity once the backups are transferred to the remote server?
View 5 Replies
View Related
Aug 19, 2007
We have recently migrated from an HP server to a new one, HP DL-380, 6 Disks ( 2 o.s. Mirror 1 + 3 database Mirror 5 + 1 Hot spare ), we instaled Windows 2003 Server, SQL-SERVER 2005 SP2 ( the old one had SQL-SERVER 2000 ) and we are runing and ERP systems that runs with Sql-Server.
We instaled the server and the soft and run it in production about a month ago, since almost the first day, the server hangs up when we run some random parts of the ERP program.
We request hp to change the mother, check the memories, the procesor, etc they told as that this isn't a hardware issue.
After further research we found that the only clue in this problem, the only big diffrence between the old server and the new one, ( among the Sql-Server version ) is that the Collation sequence is differnt, the server has ModernSpanish, the database is using SQL_Latin1_General_CP1_CI_AS, the same that has almost all other clients instalations.
We are not sure if the source of the prolbem is this, but we are runing out of ideas here. We change the Sql-Server user name that runs the process, created a new one. Again the same result.
Can anybody help with this ?
View 2 Replies
View Related
Jan 20, 2008
Is there a way to setup login authentication off a remote SQL Server 2005 Standard instead of using the SQL Server Express.
View 1 Replies
View Related
Mar 20, 2007
Hi,
When trying to connect to a SQL Server 2005 Analysis Services instance through the Excel 2007 Add-In, the ability to choose a user name/password combination rather than Windows Authentication seems to be disabled. Is there a way to do this? Thank you!
Melissa Kenny
Harvard Medical School IT
View 7 Replies
View Related
Sep 11, 2006
Hi,
not sure if this is the right place to raise this question. If not please move this message.
I configured a Sql-Server 2005 installation -that is running on my computer for test purposes- with "Windows Authentication". I had to change my Windows password recently and it seems as if SQL-Server does not accept my account anymore. The event viewer told me that service startups failed because user or password are unkown.
Does anybody know how I may get access again? The problem seems to be that I cannot change back to my old password -unless I change it six or more times...
Thanks for helping me out!
View 2 Replies
View Related
Jun 20, 2007
Hi all!!!
I have the following problem:
I used JTDS to connect to SQL Server 2005 SP1(with Windows Authentication) from a Tomcat DataSource, using your usefull ntlmauth.dll, so I can use Users from Active Directory.
All is ok until I must call a Stored procedure that excecute queries from a linked server table.
I have the following exception message "Login failed for user 'NT AUTHORITYANONYMOUS LOGON'"
I make a lot of test, I make a Java main program invoking the sotred procedure that excecute queries on linked server using JTDS and then using Microsoft SQL Server 2005 JDBC Driver 1.2(April 2007)sqljdbc.jar and Ihave the same problem, but if we use the bridge JDBC-ODBC all works OK.
Please help!!
thanks
Lore
View 4 Replies
View Related