I was using detach & attach method to move few 2000 databases to the instance 2005 on the same server...After moving a couple of databases which worked fine...Now i am not able to log into 2000 database...i guess the default database which i was connected had been moved at so its not letting me in to 2000 server..
TITLE: Connect to Server
------------------------------
We used Named Pipes network library when running SQL Server 2000. The firewall and ip address on the box were changed and reconfigured. We rebooted the server. We cannot start the SQL Server now.
Can someone please help me with troubleshooting my SQL Server authenticated user. One of the users that I created has a login name of <None>. I am unable to delete this user and recreate his login nor plug in a login name. I believe that there is a script to correct this problem but I am having trouble researching it. I am working under the gun to resolve this issue so anyones help with the issue is much appreciated.
i want to create fulltext search for that i have started Microsoft Search component but when i am tring to open SQL server Enterprise manager, i am getting sql server group but it showing "no items" not any database or any other data. what to do.
Hello All, I am not sure what is going on, but ever since I installed my ASP.NET shopping cart I keep getting the following error message in my Event Viewer under Application. If anyone out there has any idea why this is happening please let me know because it seems to be crashing my other sites on my web server. I have a Web Server which connects to a separate SQL 2000 Server. This error message is on my Web Server. Thank you all in advance for your help! Error:-------------------------------------------------------------------------------------------------------------------------- Event code: 3005 Event message: An unhandled exception has occurred. Event time: 1/6/2007 1:07:17 PM Event time (UTC): 1/6/2007 6:07:17 PM Event ID: 518a9db199214e3e807dd676e85f3d5a Event sequence: 103 Event occurrence: 6 Event detail code: 0 Application information: Application domain: /LM/W3SVC/1309570491/Root-1-128125656181152736 Trust level: Full Application Virtual Path: / Application Path: C:InetpubStoreV7 Machine name: CDMLWEB Process information: Process ID: 2376 Process name: w3wp.exe Account name: NT AUTHORITYNETWORK SERVICE Exception information: Exception type: SqlException Exception message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Request information: Request URL: http://www.bestpricetags.com/default.aspx Request path: /default.aspx User host address: 207.38.200.139 User: c2e1ff27-e0ea-4c7f-ac61-5b1716651d3b Is authenticated: True Authentication Type: Forms Thread account name: NT AUTHORITYNETWORK SERVICE Thread information: Thread ID: 10 Thread account name: NT AUTHORITYNETWORK SERVICE Is impersonating: False Stack trace: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected) at System.Data.SqlClient.TdsParserStateObject.ReadBuffer() at System.Data.SqlClient.TdsParserStateObject.ReadByte() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at AspDotNetStorefrontCommon.DB.GetRS(String Sql) at AspDotNetStorefrontCommon.DB.GetSqlN(String Sql) at AspDotNetStorefrontCommon.AppLogic.IPIsRestricted(String IPAddress) at AspDotNetStorefront.Global.Application_AuthenticateRequest(Object sender, EventArgs e) in C:InetpubStoreV7App_CodeGlobal.asax.vb:line 103 at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) Custom event details: For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
I have an urgent situation expecting your advice. I have a .net front end application running against SQL 2000 DB in a XP box, it has been working fine for two years, recently when the .Net app starts, it works still ok getting data from sql database on the first form (dislpay data retreived from a table and view in a master-client grid), while I often get timeout error when I proceed with other processes that need sql database and I noticed that the HD light on SQL server machine (XP) kept flashing when timeout error occured, seems it kept reading/writing disk. I could not even close enterprise manager from SQL Server box when the HD was busy, and it also took a considerable long time to reboot the machine. sometimes I just shut down the machine (power off) and turn on the power again, then the sql server came back to life and could work stable for a couple of days.
Do I need reindex? reinstall sql server? or might it be relating to hardware issue?
We have few branches with individual dbs are sitting in the branches itself. Periodically all the data need to be updated to a single HQ database. At the moment, all the tables's primary key are unique and each branch will have branch ID's in the transaction tables.
e.g. Branch1 data need to be updated to HQ db. However, HQ db records which are related to Branch 1 data only need to be updated back to Branch 1. other branch records should not goto Branch1.
Similaryly other branch records need to be updated/replicated back to HQ database. And only records related to the particular branch need to be updated from HQ (if any changes made)..
At the moment, i can do simple replication from one db to another db only... Can anyone guide/give suggestions on how to go about doing this?? If possible, please give steps involved...
Hi.. I am able to create a new login thru sql server enterprise manager..but when i try to connect thru query analyser using the same login and password,i am getting the following error.. Unable to connect to server EI_DT Server:Msg 18452,Level 16,State 1 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'test'.Reason:Not associated with a trusted SQL Server Connection Can anyone plzz help me to rectify this error.. Thankz in advance..
Is there a way to audit the login on SQL Server 2000? I'm looking for away to get a report login/logout events with the name of the database.Thanks in advance.
I have created a database ABC under an instance <compname est> and have assigned an user name and password for it. Also i have created another database DEF under the same instance with respective login credentials. The problem is that i can login to ABC using DEF login credentials and vice versa. Can anyone suggest a solution for this? Is there any query to create a login for a particular database?
Hello all. I have a nvarchar field in the format dd:hh:mm:ss I need to get a sum of these fields in the same format. So for example if the values are 01:23:00:00 and 00:01:00:00 then the sum of these fields should be 02:00:00:00. Can someone help me? Thanks.
I am using VS .net 2005 to develop a web application with sql server 2000, but the SQL servrer 2000 is setup on other computer,so, my web server is setup on A machine and SQL servr is setup on B machine.I got a problem when i try to connect to SQL server through the Web form as following error."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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)" I had try to setup the MDAC 2.8 on my Web Server, but i got a setup error sth like "MDAC 2.8 cannot install on your machine because it is not support your windows version.........." Why i can't connect to SQL 2000 through the Web server??? It is a urgent case, Please help thx a lot.
I am currently working on a project which requires reports that need multi-pass queries. I am currently using Crystal Report 8.5 and am not sure how to use multi-pass queries.
Here's some explanation about what I need :
A report has 10 different columns (counters). However, to get the values in all the columns, the filters (WHERE clause) are different for all the columns. The only way I can think of doing this in Crystal Reports 8.5 is using Sub-reports (that will kill my performance) or then write stored procedures to populate an intermediate table on which the report will be based on.
Is there any reporting tool in the market that will help me pass multiple queries (with different WHERE clauses) in the same report.
I would appreciate your help on the above the earliest.
Hi every one I am new meber of this community with an urgent new problem with SQL server DTS process:) pls HELP! PROCESS DETAILS:
My data base(db) is on main frame(flat file with hierarchical db format) I used vb script to get that db and split it in to three files so processing is easy after this I use dts PROCESS WITH EXECUTE SQL TASK in combination of some bulk insert scripts to pick these files from server directory and import it in to sql server tables. I know I could have use bulk insert task in dts but my formate file was giving me a problem while I try to develop it through that process so I ended up using tsql bulk insert statment with formate file in the EXECUTE SQL TASK .
PROBLEM : My problem is I have to manually activate VB script where as I want this to be part of my DTS packet so it can be automated.
I know there is Active x scripting task in DTS but have not used it can some one please tell me if this script can be put in to Active X scripting task with or with out any modifications and also what are the modifications I need to do so it can run before other DTS task (which picks the file and insert it in three different tables after format file application.
Set fso = WScript.CreateObject("Scripting.FileSystemObject")
'Set SourceFile = fso.OpenTextFile("C:SourceWGEE.NONX.GMM220D.UNLOAD.G00178888V00", ForReading) Set SourceFile = fso.OpenTextFile("C:SourceDataNotepad.txt", ForReading)
set l1 = fso.OpenTextFile("C:SourceLevel1.txt", ForWriting,True) set l2 = fso.OpenTextFile("C:SourceLevel2.txt", ForWriting,True) set l3 = fso.OpenTextFile("C:SourceLevel3.txt", ForWriting,True)
Do While SourceFile.AtEndOfStream <> True retstring = SourceFile.ReadLine
if Instr(1,retstring,"PACM",0) > 0 then Level1No = Level1No + 1 Level1Str = Rpad(Level1No," ",10) l1.WriteLine(Level1Str & retstring) End if
if Instr(1,retstring,"PACPRS",0) > 0 then Level2No = Level2No + 1 Level2Str = Rpad(Level2No," ",10) l2.WriteLine(Level1Str & Level2Str & retstring) End if
if Instr(1,retstring,"PACACC",0) > 0 then Level3No = Level3No + 1 Level3Str = Rpad(Level3No," ",10) l3.WriteLine(Level1Str & Level2Str & Level3Str & retstring) End if
Loop
Function Rpad (MyValue, MyPadChar, MyPaddedLength) Rpad = MyValue & string(MyPaddedLength - Len(MyValue), MyPadChar) End Function
I've a database in 2000 which needs to be accessed from 2005 via linkedserver. I've tried the GUI options and it is failing. One thins is that ourboth servers have hyphen('-' not underscore, could that be a problem) in thenames, like 2k-srv and 2k5-srv as hosts, but the instances are default.Can anyone give me the steps please.TIANasir
when my ASP.NET 2.0 web site working against MS SQL Server 2000,I Usually have a connection string to the DB, I create a connection, and start working on the data. While reading about the MemberShip provider of ASP.NET 2.0 (Login control, Forgot password, etc.),I read that it's possible to save the MDF file of the membership controls, within the APP_DATA folder. But how can it be ? the MDF file must be at the server folder,How can I access this MDF file ? with which connection string ?How does MS SQL Server 2000 syncronize against this MDF file within my APP_DATA folder ? And by the way, if my hosting company allow me to use 1 db schema of the MS SQL Server 2000 server,Does this method (saving the MDF file within thr APP_DATA folder) allow me to use multiple schemas ? Thanks.
I am using SQL Server 2000. But i am not able to see the BuiltinAdministrator account in the logins list in Enterprise Manager but by default the owner of the system gets access to all databases and objects in the system. I would like to restrict that by restricting the access of BuiltInAdministrator account but it is not visible. Is there any option to be enabled to make that visible?
if i try to delete data via MFC from Microsofts SQL Server 2000 i get following message: Data can be read only.. Weird i can write and read already. do i have to setup anything in Micrsofts SQL Server 2000 ??
I got a shared web hosting server with sql server db which is 2k, and now ive got dedicated with godaddy where i installed sql 2005 express edition, now my shared hosting ppl gave me db bkup which i cant restore , so i copied all data from asp.net web based enterprise manager into an excel sheet and am trying to copy that data into sql2005 management studio express, however it doesnt let me do that.
I am trying to use openrowset, but my knowledge in sql is minimal so cant run that either.
can you please please please tell me how to do this asap, its very urgent as my contract runs out with shared hosting on 31 and ive to switch this site live by tomorrow.
please let me know asap wat to do, i can pay also for this job?
hello, I have developed a website using asp.net 2.0 and sql server 2005 express edition. I have used the built-in membership, roles and login controls in my website. now i need to change the database server. i have to use sql server 2000 instead. as asp.net 2.0 uses the ASPNETDB.mdf for member,roles and login controls, so how can i do it? i can easily export the database from 2005 to 2000 but how my application controls will know where to look at for those data. I am clueless. please help me. thanks in advance.
I am trying to do a unattended upgrade of an MSDE 2000 named instance, say MyInstance, to a SQl Server Express Advanced edition. The set up is Mixed Mode Authentication. ( I can't use Windows Authentication for business reasons). The error I get is
SQL Server Setup Cannot Upgrade the specified instance by using SQL Server Creditial. You must use Windows Authentication creditial for the upgrade.
Details are as follows: OS: Windows XP Prof (SP2). Original install: MSDE 2000 Instance name: MyInstance Authentication: SQL Registry Entry: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerMyInstanceMSSQLServer Key LoginMode has a value of 2 ( corresponding to Mixed Mode Auth)
Upgrade attempted to: SQL Server Express Adv. Command Line: start /wait setup.exe /qn LOGNAME=C:setup.cab /settings E:Sql2005SqlTemplate.ini
The error I get in Summary.txt: Machine : xxxxxXP Product : SQL Server Database Services Error : SQL Server Setup cannot upgrade the specified instance by using SQL Server credentials. You must use Windows Authentication credentials for the upgrade.
Can't I use SQL Authentication? I could not find a definitive answer on this one. Here's one thread that seem to indicate the same issue
My questions: - Can I use SQL Authentication? - Where am I going wrong? - I know the error message says to use Windows Authentication but I don't understand why I am I forced into using that.
I've successfully carried out pull subscription using Wizard in SQL server 2000.
But NOW its the time to deploy the project & I've to do it programatically........
i tried to use the default stored procedures like "sp_addmergepullsubscription ", "sp_addmergepullsubscription_agent ", "sp_reinitmergepullsubscription ", with respective parameters.
Then using replmerge.exe i tried to execute the batch file But could not succeed......
Can anyone guide me from the Basics ??? (i knw the Replication Architecture its heirarchy....but have NO idea of performing it Programatically......!!!!!!!!)
by BASICS, i mean......how should i execute the resp. stored procedures with what parametes & the order i should follow in order to successfully pull a merge subscription in SQL server 2000.
if a Sample code is mentioned as example, would be better for me to understand....
How do I add login user ASPNET to my SQL 2000 Desktop Engine Server?. I can not find the "Server Manager" in the Start - Programs. Is there any other way to get around adding ASPNET login to the SQL server so I can test my VB program. I got the error: Login failed for user 'com_nameASPNET'.
I install a replication with two servers serv1 and serv2. serv1 is a distributor and publishing server. serv2 is subscriber server. my database name in serv1 is 'test',and the database distribution name is'test_distribution' (it is in serv1). in serv1 , i execute this commande: ->sp_dropserver serv2 ->sp_addserver serv2 ->sp_addremotelogin serv2,sa,sa The security mode in the two servers is 'standard'. my probleme is this: when i want to install subscribing server (serv2) i receive this message: ->Unable to connect to site 'serv2'because login failed.
I made a backup of a production database and copied that backup over to a development server and restored the database. Now I have users saying that the application is failing on development. I have users that have NT authentication and some with SQL authentication.
What is the best way to get everything to sync up again?????
i am developing an installer for our produce where there is a need to install sqlexpress and then i have to attach the database to that but i am unable to understand how to do that , i any one can help in this issue plss
Hi all, I am using forms authetication to log in to reporting services. I am using logonuser method of reporting services web service. I am getting the following error when i try to log in
System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: An error occurred while attempting to verify the user.Login failed for user 'SON-1499IUSR_SON-1499'. at Microsoft.Samples.ReportingServices.CustomSecurity.AuthenticationUtilities.VerifyPassword(String suppliedUserName, String suppliedPassword) at Microsoft.Samples.ReportingServices.CustomSecurity.AuthenticationExtension.LogonUser(String userName, String password, String authority) at Microsoft.ReportingServices.WebServer.RSCustomAuthentication.LogonUser(String userName, String password, String authority) at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.LogonUser(String userName, String password, String authority) at Microsoft.ReportingServices.WebServer.ReportingService2005.LogonUser(String userName, String password, String authority) --- End of inner exception stack trace ---
I have LocalMachine/ASPNET web service identity set in Reporting Services Configuration on Windows XP .
Have just tried my sql server 2005 connected asp classic website on II7 for the first time and have gotten some errors. First off I have unchecked show friendly errors in IE and have enabled ASP to send error messages to the browser.
My error I get is when I execute a basic .asp page:
Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "mydatabasename" requested by the login. The login failed. /index.asp, line 10 which is dbConnect.Open cstring
from this peice of code:
sub dbOpen() set dbConnect = Server.CreateObject("ADODB.Connection") cstring = "DSN=mysqldsn; Trusted Connection=yes" dbConnect.Open cstring end sub
I have gone into ODBC and have setup both a user dsn and file dsn that equals mysqldsn and points to my database (I know you only need to set up one DSN but I'm not sure which)
I also notice under mywebsite home panel there is a connection string option. Do I do anything with that?
