SQL 2005 SP1 On Win2003 R2 - Is It Supported/ Certified?
May 31, 2006Can anybody point me to a Microsoft official document that says anything about the support/ compatibility between SQL 2005 + SP1 and Win2003 server R2 ?
Thanks
ADVERTISEMENT
SQL 2005 Certified
May 5, 2008Hi, I want to get certified in SSIS,SSRS & SSAS
The exam number is 70-445 (course: 2791,2792,2793)
I would like to know is there no tuctorails, self test exams or practises that can assist with passing the exam.
I have the manuals that came with the course & i have some experience but would like to get an idea of how the test & questions will be.
Please any materail or help.
Regards
How To Become A SQL 2005 SSIS And SSAS Certified Profession? Where To Start?
Jun 26, 2007I am very keen to go into the BI area with SQL 2005, somebody suggested me to go more specialized in SSIS and SSAS. I heard there is a certified programme in BI track which was just launched last year by Microsoft, but I couldn't find the info anymore, could anybody here help providing some information for me to get started?
I do not have any MCSE yet. Is there a need to get some basic MCSE before jumping into the BI track?
Thanks a lot!
Jet.OLEDB.4.0 And Linked Servers (SQL Standard 2005 On Win2003 SP1)
Dec 5, 2006I have been trying to figure out for some time why Linked Servers do not continue to run. I start up my SQL Server Database service, and then using SQL Server Management Studio I create one or more linked servers to Microsoft Access Databases using the Jet Provider. I then run some queries to that access those linked servers without any problems. (One currently is called 'THE')
After some time has passed, possibly minutes, hours or days, I can no longer access any of the linked servers. No data, queries, tables, or anything is accessible to me anymore. I use this command "EXEC sp_testlinkedserver N'THE' " to test the linked server and get the following error msg.
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "THE" returned message "Unspecified error".
Msg 7303, Level 16, State 1, Procedure sp_testlinkedserver, Line 1
Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "THE".
The only solution I have to fix this currently is to restart the SQL Server Database service. I have tried deleting and recreating the Linked server before doing this to no avail. I have also used the FileMon and RegMon tools on the server to try to determine the problem but have no no success. After restarting the SQL service I can run the "EXEC sp_testlinkedserver N'THE' " command successfully "Command(s) completed successfully." and can access the linked servers again without any problems.
Any help with this is greatly appreciated.
Mark.
P.S. I have tried changing the security options on the linked server from "Be made without a context." to using the "Admin" username and leaving the password blank, to several other possible variations and options, as well as setting up the system.mdw database in the registry to no avail.
SQL Server Certified For Vista And MS SharePoint
Oct 29, 2007Hello,
I have (2) questions about SQL versions and (1) question about "Standard Log Sizing" for SharePoint directory. I am pretty sure about SQL 2000 versions "Not being Certified".
1) Which versions of MS SQL Server 2000 and 2005 are certified to run on Vista?
2) Which versions of MS SQL Server 2000 and 2005 are certified to run on Internet Explorer 7 (IE7)?
3) What should the "Standard Log Sizing" be for MS SharePoint Server drive be? Or is there an actual standard?
Thank you.
Windows 2003 SP2 Is NOT A Supported OS For SQL 2005 SP2???
Apr 5, 2007Maybe this is just an oversight in the documentation? Here it is for all to see on the download page for SQL 2005 SP2:
http://tinyurl.com/35nunk
Note the supported operating systems:
Windows 2000 Service Pack 4; Windows Server 2003 Service Pack 1; Windows Vista; Windows XP Service Pack 2
NO mention of Windows 2003 Service Pack 2, but Windows 2003 Service Pack 1 is specifically mentioned.
Any ideas on this one? Thanks!
Chris
Is DAC Supported In SQL Server 2005 Express Edition?
Nov 10, 2007Hi All,
Can you please kindly let me know whether DAC(Dedicated Administration Connection) is supported in SQL Server 2005 Express Edition. As per the documentation available in MSDN(Trace Flags), Trace Flag
7806 Enables a dedicated administrator connection (DAC) on SQL Server Express. By default, no DAC resources are reserved on SQL Server Express.
But when i tried to enable it by passing -T7806 as a parameter to SQL Server (SQL Express) service, the following information is logged into event viewer
Dedicated administrator connection support was not started because it is not available on this edition of SQL Server. This is an informational message only. No user action is required.
Also, the following error message is displayed when I tried to connect to DAC from command prompt
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 43 - An error occurred while obtaining the dedicated administrator connection (DAC) port. Make sure that SQL Browser is running, or check the error log for the port number) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
The version of SQL Server I'm using is
Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 6.0 (Build 6000: )
Can someone kindly me help me to enable DAC of SQL Express edition?
Many thanks in advance.
Gopoinath
Tech Thoughts
Features Not Supported In Compatibility Level 80 Of SQL Server 2005
Oct 23, 2007Hello All,
I am in the process of upgrading my current database in SQL Server 2000 to SQL Server 2005. I have finished my analysis using the upgrade advisor and have found a lot of SPs having upgrade related issues. From what I estimate I think it will take around 3-4 weeks to resolve all of those issues. I wanted a quicker way to upgrade my database since we have very little time for the final release. The main reason for upgrade to 2005 was use of new features like Database Mirroring and/or peer to peer replication alongwith the Partitioning features and the new T-SQL enhancements.
The question I wanted to ask was does the compatibility level 80 of SQL Server 2005 supports these new features.
From what I have read on the KB article at http://support.microsoft.com/kb/822400 is that mirroring is supported in any compatibility level, but there is no specific mention on the peer to peer thing.
Also when I personally tried using the New Partitioning Features of 2005 on the database having compatibility 80, it worked fine. Also other features like SQLCLR and TRY...CATCH works fine.
One thing I observed was that new T-SQL statements like PIVOT/UNPIVOT is not supported
It will be nice if someone can give out the entire list of features that will be supported in the compatibility Level 80 and also the list of the ones that are not supported.
Thanks in Advance,
Mitesh
On Which Platforms Is SQL Server 2005 Compact Edition Supported.
Dec 2, 2006Will it be possible to run SQL Server 2005 Compact Edition on the following platforms:
Windows 2000
Windows XP (if yes then on which versions of it)
Vista x86
Vista x64
Are there OLE DB providers for SQL Server 2005 Compact Edition?
List Of Supported Components For SQL Server 2005 Standard Edition?
Jan 17, 2006Please can someone give me a url or even their own list of support / unsupported components in SQL server 2005 Standard edition.
I know fuzzy lookup is not supported. Is a slowly changing dimension supported?
Its a bit difficult to tell when I get bizzare "Product level is insufficient" error for even a basic derived column transformation when executing a package using SSIS unless it is executed using a scheduled job....
thanks,
Nicole
Are Integration Services Fully Supported On Named Instances Of 2005?
May 30, 2008Hi folks
I have deployed a package from file resources to sql server named instance. I did not receive any errors. msdb..dtspackages90 table have rows for my package.
But when I try to connect to integration services using ssms like 'serverinstance', I am getting an error saying that 'serverinstance' names are not supported by integrated services and I should use just a servername.
What am I doing wrong? Is that really integration services are not supported on named instances or i miss something?
Thank you, Gene.
Upgrade SQL 2005 Evaluation To Workgroup/Standard Without Uninstalling: Supported?
Jan 25, 2007Hi, all. I see two conflicting notes about whether one can install the SQL Server 2005 Trial/Evaluation and then upgrade to Workgroup or Standard editions, without uninstalling the Evaluation edition.
http://msdn2.microsoft.com/en-us/library/ms143393.aspx seems to say YES, you can upgrade to Workgroup/Standard from the Evaluation edition.
http://www.microsoft.com/sql/howtobuy/faq.mspx says NO, you can only upgrade to Enterprise edition from the Evaluation edition. For Workgroup and Standard, you must uninstall the Trial first.
Which is the correct answer?
Thanks,
Stephen
SQL Server 2005 Database Mail Command Not Supported (502) SMTP Error
Dec 4, 2006Hi all,At this moment I'm trying to get database mail working. According tosome people it should be easy. Well...that is not the case for me.I'm having the following error:The mail could not be sent to the recipients because of the mail serverfailure. (Sending Mail using Account 2 (2006-11-24T08:48:15). ExceptionMessage: Cannot send mails to mail server. (Command not implemented.The server response was: Command not Supported).)SQL Server 2005 is installed on a separate server and the SMTP Serveris Lotus Notes. connecting with port 25.Start and stopping the SQL Server and SQL Server agent i tried already.i tried sysmail_stop_sp and sysmail_start_sp.Sometimes when starting or stopping the Mail with the followingcommands :exec sysmail_stop_spGOexec sysmail_start_spGOI will get the following error:Msg 233, Level 20, State 0, Line 0A transport-level error has occurred when sending the request to theserver. (provider: Shared Memory Provider, error: 0 - No process is onthe other end of the pipe.)So any help would be appreciated.Hennie
View 1 Replies View RelatedSQL Server 2005 Issue - The Cursor Type/concurrency Combination Is Not Supported.
Jun 19, 2007Hi
I have recently upgraded from SQL 2000 to SQL 2005 and I'm getting the following problem, can you suggest me if this is a issue with SQL 2005 or suggest me an asnwer for this.
Below is the exception from my log file
The cursor type/concurrency combination is not supported.
com.microsoft.sqlserver.jdbc.SQLServerException: The cursor type/concurrency combination is not supported.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.<init>(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.<init>(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.prepareStatement(Unknown Source)
The following is the piece of code where the problem I'm assuming is happening, how can I correct it.
varStmt1 = varConnection.prepareStatement(varCitationSQL.toString(),ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);
Have tried using both JDC v1.1 and 1.2 but of no use.
Win2003 AD + Sql2000 Without Netbios?
Dec 22, 2004i'm running a standalone server that is on windows 2003 enterprise, sql server 2000 enterprise and has active directory and dns installed.
from what i know it IS possible to go without netbios in a domain with all win2000+ comps. however is there anything that will break down in regards to sql server 2000?
Win2003 SP2 Fix Causes Problems On RS2000
Aug 15, 2007We just applied SP2 to our Windows 2003 server & it has had an odd impact RS2000.
When trying to change the data source of a report to a shared data source, the browse button when clicked does not take you to the page to enable selection! It does nothing!
Does anyone have any ideas on what's going on there?
Sql2000 On Win2003 Server
Sep 13, 2006Hi,
I want to install SQL 2000 Server on Win-2003 STD Server and transfer the database that has been running on SQL-2000/Win 2K server.
Win-2003 Server has Apache services and TrendMicro AV Server running. After installation the SQL service starts automatically. But I am not able to see the database from Enterprise manager. It gives error 'A connection could not be established to <local>. Reason: Login failed for DOMAIN/USER. I am logged into Win2003 server as 'Administrator' for installation. SQL Server authentication in Mixed Mode and connect using Domain user account.
While applying update(SP3) also the same error comes after trying to validate password and the Sql service automatically stops. I tried using both Win pwd and SQL sa pwd. Both are giving same error.
How I can go abt it?
Shall be grateful for a reply,
Files Not Creating On Win2003
Oct 29, 2006I have created a package which extracts data from a table and creates several files. This works fine on my PC (WinXP SP2), but when i deploy it to the server it doesn't work. I have also tried to create the package from scratch on the server as the administrator and it still has the same problem. Anyone have any ideas?
View 7 Replies View RelatedWin2003 / Sql2000 Memory Usage
Jun 20, 2007I have googled by heart out trying to find answers to this and am onlymore confused.DB Server:Windows Server 2003 Enterprise4 GB memorySQL Server 2000 Enterprise Edition, SP4 8.00.2039The SQL server process appears to be using a steady 1.7 gb of memory.There are no other memory intensive applications running on thisserver as reported by Task Manager.I have read all about the 2gb/process limit and the /3gb boot switchand all but most of that seems to apply to windows 2000, not 2003. I'dlike SQLServer to use more of the memory if it can (assuming it wouldbe advantageous for performance).Can anyone sum this up for me?Thanks,Michael
View 1 Replies View RelatedWinNT 4.0 And Win2003 Server (AD) Environment
Mar 12, 2007We have a combined network with some users on the old Windows NT 4.0 network and others on the new Windows 2003 servers using Active Directory. Will my users on the old WinNT4.0 domain have issues accessing / running reports from Report Manager?
URGENT- How To Install .net Framework On Sql Cluster2k On Win2003.
Aug 31, 2004Hello,
I am planning to install .NET on sql2k cluster on Win2003 server.
Is there any document(s) available to install .net framework on sql2K cluster on win2003 server?..
Please post the link if available.
If NOT
What is the procedure to install .NET on sql2k cluster on Win2003 server?.
Thanks for the help
mka
Urgent: Strong SAPWD Required On Win2003
Jun 3, 2008Hi folks.
I just tried to perform the install of SQLServer 2005 Express on a Win 2003 SP2 machine and the install failed with the rejection of the SA password. Currently, our pwd is 1 uppercase letter, 4 lowercase letters and 1 number for a total of 6 characters. Other installations on Win 2003 SP1 have worked fine in the past. I read in a recent version of Books Online that the SA pwd guidelines might have recently changed and that 8 characters might now be required.
My question is: do these new 8 character guidelines apply only to the sa pwd or to all logins?
Thanks!
Mike
Authorization Error In Reporting Services On Win2003
Jul 23, 2005Hi,I have just reinstalled Reporting Services on win 2003 server that wasadded to a domain and has been renamed. Two strange things happen:1) In IE I am prompted for an ID and password with a basic securityprompt.2) After supplying the credentials I get some of the report manager webpage but it has a 401 error instead of the folder and options to manageprojects.The page looks like this:ErrorThe request failed with HTTP status 401: Unauthorized.HomeThe reporting services error log contains the following error:Unknown!ui!ed8!2/9/2005-20:44:32:: v VERBOSE: Usermap'<Users><User><Name>DOMAINAdministrator</Name><Paths><Path>/reports/Home.aspx</Path><NrReq>1</NrReq></Paths></User></Users>'Unknown!ui!a24!2/9/2005-20:44:33:: v VERBOSE: Usermap'<Users><User><Name>DOMAINAdministrator</Name><Paths><Path>/reports/Pages/Folder.aspx</Path><NrReq>1</NrReq></Paths></User></Users>'Unknown!ui!a24!2/9/2005-20:44:34:: e ERROR: The request failed withHTTP status 401: Unauthorized.Unknown!ui!a24!2/9/2005-20:44:35:: e ERROR: HTTP status code --> 500I have not changed any of the config files that are installed.Thanks for any help in advance,Eric
View 1 Replies View RelatedConnection Is Busy With Results For Another Hstmt && Win2003 SP1
Jul 23, 2005I wrote a web app using an ASP front end (not .NET) connecting to a SQLServer 2000 (no SP) back end. Both the web server and the databaseserver are Windows 2003 boxes. The app was running fine two weeks agobefore I went on vacation. While I was gone my net admin appliedWindows 2003 SP1 to the web server. Upon my return I was informed thatthe app is no longer working, getting the following error:[Microsoft][ODBC SQL Server Driver]Connection is busy with results foranother hstmtSince that is presumably the only thing that changed in my absence Ibelieve the SP somehow messed up the way the ODBC was working. I triedmoving the SQL Server database to a different Windows 2003 box whichalso received the SP1 update and also includes SP3 for SQL Server, butget the same error.I am hitting the database like so:set GetData = CreateObject("ADODB.Command")GetData.ActiveConnection = SQLConnGetData.CommandText = "<stored procedure call>"Set DataRS= GetData.Execute (,,adCmdText)I appear to get the error when I execute the second call. I amlearning ASP as I go, so maybe this is a trivial problem.
View 2 Replies View RelatedCannot Install SQL Express On A French Win2003 Server OS
Mar 30, 2007This one has me scratching my head. We can install SQL Express on many different English OS without problems, but when we try it on a French OS it doesn't work. We have several French systems and SQL Express does not install on any of them. Even just running the SQLEXPR32.EXE without paramaters give the same error. We have yet to try it on other foreign OS. The command line we use to install is:
SQLEXPR32.EXE /qb INSTANCENAME="TESTINSTANCE" ADDLOCAL=ALL SECURITYMODE=SQL SAPWD=<StrongPassword> DISABLENETWORKPROTOCOLS=0
I've tried various solutions from these links:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=136496&SiteID=1
http://www.developersdex.com/sql/message.asp?p=1870&r=4699024&Page=1
http://www.developersdex.com/sql/message.asp?p=1870&r=4699024&page=2
However, none of them work. Has Microsoft actually tested the installer on a foreign OS? Below is the details of the setup log file:
Microsoft SQL Server 2005 Setup beginning at Thu Mar 29 14:09:31 2007
Process ID : 2232
c:f66fbb131aeb0b5e04aed9ecb936c1setup.exe Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2007/2/29 14:9:31
Complete: LoadResourcesAction at: 2007/2/29 14:9:31, returned true
Running: ParseBootstrapOptionsAction at: 2007/2/29 14:9:31
Loaded DLL:c:f66fbb131aeb0b5e04aed9ecb936c1xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2007/2/29 14:9:31, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 124
----------------------------------------------------------
writeEncryptedString() failed
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 123
----------------------------------------------------------
Error Code: 0x80070002 (2)
Windows Error Text: Le fichier spécifié est introuvable.
Source File Name: cryptohelpercryptsameusersamemachine.cpp
Compiler Timestamp: Wed Jun 14 16:28:04 2006
Function Name: sqls::CryptSameUserSameMachine:rotectData
Source Line Number: 50
2
Could not skip Component update due to datastore exception.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "2232"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2007/2/29 14:9:31
Complete: ValidateWinNTAction at: 2007/2/29 14:9:31, returned true
Running: ValidateMinOSAction at: 2007/2/29 14:9:31
Complete: ValidateMinOSAction at: 2007/2/29 14:9:31, returned true
Running: PerformSCCAction at: 2007/2/29 14:9:31
Complete: PerformSCCAction at: 2007/2/29 14:9:31, returned true
Running: ActivateLoggingAction at: 2007/2/29 14:9:31
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupStateScope"
00CBCFC4Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: Le fichier spécifié est introuvable.
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
Class not registered.
Failed to create CAB file due to datastore exception
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "2232"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2
We really need to get this resolved. Thanks! Jon.
SQL 2000 Server Does Not Start In A Win2003 Cluster
Nov 5, 2007 We have a sql2000 clustered server running on a windows 2003 cluster, today we noticed that the
SQL resources where in a Online Pending state and do not came up anymore.
I have searched the net and found some info about the sqlstate = 08001 Native error 11 , witch indicated that the SQL Network name could have been renamed , however this is not the case here , .
i also found that there might be Resolve issue but The Cluster Name and the SQL Network name can be resolved by both Cluster nodes ..
does anyone here got experience with this kind of problem ? Pls Help
Here is a part of the cluster.log with the errors :
ERR SQL Server : [sqsrvres] ODBC sqldriverconnect failed
ERR SQL Server : [sqsrvres] checkODBCConnectError: sqlstate = 08001; native error = 11; message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
ERR SQL Server : [sqsrvres] ODBC sqldriverconnect failed
ERR SQL Server : [sqsrvres] checkODBCConnectError: sqlstate = 01000; native error = 2; message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
ERR SQL Server : [sqsrvres] ODBC sqldriverconnect failed
ERR SQL Server : [sqsrvres] checkODBCConnectError: sqlstate = 08001; native error = 11; message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
ERR SQL Server : [sqsrvres] ODBC sqldriverconnect failed
ERR SQL Server : [sqsrvres] checkODBCConnectError: sqlstate = 01000; native error = 2; message = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
INFO [CP] CppRegNotifyThread checkpointing key SOFTWAREMicrosoftMicrosoft SQL ServerDBHSBMSSQLSERVER to id 4 due to timer
INFO [Qfs] QfsGetTempFileName C:DOCUME~1SRVCCL~1LOCALS~1Temp, CLS, 13 => C:DOCUME~1SRVCCL~1LOCALS~1TempCLSD.tmp, status 0
According to the SQL server log the server is started and all databases are brought on-line then a stop request from Service Control Manager terminates SQL Server see log below:
2007-11-05 14:04:02.89 server Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: )
2007-11-05 14:04:02.89 server Copyright (C) 1988-2002 Microsoft Corporation.
2007-11-05 14:04:02.89 server All rights reserved.
2007-11-05 14:04:02.89 server Server Process ID is 3264.
2007-11-05 14:04:02.89 server Logging SQL Server messages in file 'P:mssqlMSSQL$DBHSBlogERRORLOG'.
2007-11-05 14:04:02.89 server SQL Server is starting at priority class 'high'(2 CPUs detected).
2007-11-05 14:04:03.61 server initdata: Warning: Could not set working set size to 823168 KB.
2007-11-05 14:04:03.66 server SQL Server configured for thread mode processing.
2007-11-05 14:04:03.72 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2007-11-05 14:04:03.77 server Attempting to initialize Distributed Transaction Coordinator.
2007-11-05 14:04:06.32 spid2 Starting up database 'master'.
2007-11-05 14:04:06.52 spid2 Server name is 'HSBSQL01DBHSB'.
2007-11-05 14:04:06.52 spid5 Starting up database 'msdb'.
2007-11-05 14:04:06.52 spid6 Starting up database 'model'.
2007-11-05 14:04:06.52 spid8 Starting up database 'dbHSB'.
2007-11-05 14:04:06.52 server Using 'SSNETLIB.DLL' version '8.0.2039'.
2007-11-05 14:04:06.56 server SQL server listening on 10.122.131.103: 1433.
2007-11-05 14:04:06.62 spid8 Analysis of database 'dbHSB' (7) is 100% complete (approximately 0 more seconds)
2007-11-05 14:04:06.63 server SQL server listening on TCP, Shared Memory, Named Pipes.
2007-11-05 14:04:06.63 server SQL Server is ready for client connections
2007-11-05 14:04:06.66 spid6 Clearing tempdb database.
2007-11-05 14:04:07.10 spid6 Starting up database 'tempdb'.
2007-11-05 14:04:07.20 spid2 Recovery complete.
2007-11-05 14:04:07.20 spid2 SQL global counter collection task is created.
2007-11-05 14:04:16.41 spid1 Warning: unable to allocate 'min server memory' of 1658MB.
2007-11-05 14:10:45.18 spid2 SQL Server is terminating due to 'stop' request from Service Control Manager.
Odd Syntax Error With Shape Queries SQL2000/Win2003
Jul 20, 2005Hi,I am running SQL Server 2000 SP3 on Windows Server 2003 and since recentlyhave a strange problem executing shape queries from COM+ components usingADO.Until 4 days ago, they worked, then from one moment to the next (I must havechanged something, but I have no clue what other than restoring a 1.2 GBdatabase) they started failing with this error:Microsoft OLE DB Provider for SQL Server error '80040e14'Syntax error or access violationI have no problem executing non-shape queries, it is just the shape queriesthat fail.Any clues what may have gone wrong? Or how I can fix it?Cheers,Rsa Myh
View 1 Replies View RelatedAny Embedded Tool In Win2003 Or SSIS For Extracting The Files From ZIP
Jun 20, 2007Who knows whether exists embedded tool in win2003 or SSIS for extracting the files from ZIP?
Thanks in advance.
Running A Distributed Query Against A Loopback Linked Server In SQL Server 2005 Is Not Supported
Aug 27, 2007I receive the following error message when I run a distributed query against a loopback linked server in SQL Server 2005:
The Microsoft Distributed Transaction Coordinator (MS DTC) has cancelled the distributed transaction.
To resolve this problem, I was told that running a distributed query against a loopback linked server is not supported in SQL Server 2005. And I am suggested to use a remote server definition (sp_addserver) instead of a linked server definition to resolve this problem. (Although this is only a temporary resolution, which will deprecate in Katmai)
However, I run into another problem when I use the remote server definition. I receive the following error message:
Msg 18483, Level 14, State 1, Line 1
Could not connect to server 'ServerNameSQL2005' because '' is not defined as a remote login at the server. Verify that you have specified the correct login name.
Could anyone please help me out?
(I include the reproduce steps for the first error message, followed by my resolution that generates the second error message)
======
Reproduce steps for the first error message
======
On the ComputerAInstanceA instance, run the following statement to create a database and a table:
CREATE DATABASE DatabaseA
GO
USE DatabaseA
GO
CREATE TABLE TestTable(Col1 int, Col2 varchar(50))
GO
INSERT INTO TestTable VALUES (1, 'Hello World')
GO
On the ComputerBInstanceB instance, run the following statement to create a database and a table:
CREATE DATABASE DatabaseB
GO
USE DatabaseB
GO
CREATE TABLE TestTable (Col1 int, Col2 varchar(50))
GO
On the ComputerAInstanceA instance, create a linked server that links to the ComputerBInstanceB instance. Assume the name of the linked server is LNK_ServerB.
On the ComputerBInstanceB instance, create a linked server that links to the ComputerAInstanceA instance. Assume the name of the linked server is LNK_ServerA.
On the ComputerBInstanceB instance, run the following statement:
USE DatabaseB
GO
CREATE PROCEDURE InsertA AS
BEGIN
SELECT * from LNK_ServerA.DatabaseA.dbo.TestTable
END
GO
On the ComputerAInstanceA instance, run the following statement:
USE DatabaseA
GO
INSERT INTO TestTable
EXEC LNK_ServerB.DatabaseB.dbo.InsertA
GO
Then I receive the first error message.
=======
My resolution that generates the second error message
=======
On the ComputerBInstanceB instance, run the following statement:
sp_addserver 'ComputerAInstanceA'
GO
sp_serveroption 'ComputerAInstanceA', 'Data Access', 'TRUE'
GO
USE DatabaseB
GO
CREATE PROCEDURE InsertA AS
BEGIN
SELECT * FROM [ComputerAInstanceA].DatabaseA.dbo.TestTable
END
GO
On the ComputerAInstanceA instance, run the following statement:
USE DatabaseA
GO
INSERT INTO TestTable
EXECUTE [ComputerBInstanceB].[DatabaseB].[dbo].[InsertA]
GO
Then I receive the second error message.
Upgrading SQL 2005 Enterprise Evaluation To Enterprise Full Not Supported On Win XP Professional
Jul 11, 2006This may be a stupid question, but can someone from MS SQL Server Team kind enough to confirm it, please?
View 3 Replies View RelatedSQL Server Does Not Exist Or Access Denied. Error While Moving App From Winxp To Win2003
Mar 28, 2005hi,
I have an asp.net application which queries an sql server in some other domain and populates a grid with the results.
i am using sql server authentication and my connection string is as follows:-
Dim connectionString As String = "server=emr01; user id='private'; password='private'; database='NGEMRDev'"
i have also used the following tag in web.config:-
<identity impersonate="true" />
This works fine on my development pc i.e windows xp with sp2 .
but when i tried running the same application in windows 2003 the query gives the following exception:-
Server Error in '/TempDel' Application.
SQL Server does not exist or access denied.
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: SQL Server does not exist or access denied.Source Error:
Line 77: dataAdapter.SelectCommand = dbCommand
Line 78: Dim dataSet As System.Data.DataSet = New System.Data.DataSet
Line 79: dataAdapter.Fill(dataSet)
Line 80:
Line 81: Return dataSetSource File: c:inetpubwwwroot empdelemrtempdel.aspx Line: 79 Stack Trace:
[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +472
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
ASP.EmrTempDel_aspx.MyQueryMethod(String username) in c:inetpubwwwroot empdelemrtempdel.aspx:79
ASP.EmrTempDel_aspx.Button2_Click(Object sender, EventArgs e) in c:inetpubwwwroot empdelemrtempdel.aspx:89
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +58
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032
Please help me as to how do i successfully implement my application in the windows 2003 server. i have given the aspnet user on the win2003 admin rights.
Memory Limits Sql 2000 Entp On Win2003 Entp
Apr 27, 2006AM I correct that with a quad box running sql server 2000 enterprise edition running on windows 2003 enterprise edition, I can put 32 gig of memory which sql server can use. Need response ASAP, Thanks
View 2 Replies View RelatedDAC Not Supported.
Aug 7, 2006SQL2K5
SP1
Howdy all. I'm trying to open up Dedicated Admins Connection in Management Studio and getting "DAC's are not supported. (Object Explorer)"
Any idea's?
TIA, cfr