Dear All!
I have installed my sa password "sa" during my MSDE (desktop engine of sql) installation.
currently i am loging into query analyzer using windows authentication.
But i cant access the database through my code, coz i dont have sa access.
Please kindly Help me finding my current sa password.
Thank You!
Hello everybody,
I'm a SSiS newbie and I'm trying to reproduce my old DTS from sql server 2000 into this new SSiS.
I need to retrieve data through ODBC from a SAP db. I've got the right DNS and it works (Test connection succesful), but I'm unable to store password in connection manager.
I tryied to foigure out why and how to solve this problem, and I found somehthing on this forum talking about changing configuration files or something else... I'm a newbie, I don't know which files you're talking about..
Can you explain me in the simplest way possible how to store password in connection manager?
thanks in advance
I have recently changed my NT password and since then one of my machines has not been able to start MSSQL server. When I re-boot the machine it lets me know that it was unable to start MSSQL server. If I right click on the SQL server group in EM and try to manually start the service, it tells me that I have a login failure. I don't understand how changing my NT password would affect one machine and not the others. When I right click on the "edit SQL service registration properties" tab, all of the machines are using the NT password selection as opposed to the SQL server authentication password. Any ideas would be greatly appreciated
View 1 Replies View RelatedHi,
I think my description says it all. I have just installed Studio Express for the first time.
I want to attach a database. When the connect to server dialog is displayed the user name and password text box is greyed out. The Password box is blank and I need to edit this. I switch to SQL authentication they are enabled but if I switch back to Windows authentication they are both greyed out.
I have uninstalled and reinstalled but still no luck,
Any help would be great.
I am not able to connect to Remote Distributor from Publisher using Administrative Link Password. I have configured the Distributor on 1 m/c and Publisher on another m/c. When i use the wizard to configure the publisher using remote distributor. I have also specified the same Admin Password link (distributor_admin) in the distributor m/c.
I am getting the following message:
TITLE: New Publication Wizard------------------------------
SQL Server could not connect to the Distributor using the specified password.
[URL]
------------------------------ADDITIONAL INFORMATION:
Connection to server [SANMENON] failed.OLE DB provider "SQLNCLI" for linked server "D956CF83-AE2E-4FC5-83DD-BE90D84A3950" returned message "Login timeout expired".OLE DB provider "SQLNCLI" for linked server "D956CF83-AE2E-4FC5-83DD-BE90D84A3950" returned message "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.". (Microsoft SQL Server, Error: 21670)
[URL]
------------------------------BUTTONS:
OK------------------------------
I am trying to change password, using the code below.. The code below is in a stored proc and I am passing these parameters from a web application.....
sp_password [ [ @old = ] 'old_password' , ] { [ @new =] 'new_password' } [ , [ @loginame = ] 'login' ]
sp_password 'cust1','cust2','cust1'
Server: Msg 15210, Level 16, State 1, Procedure sp_password, Line 20Only members of the sysadmin role can use the loginame option. The password was not changed.
I made my user part of the db_securityadmin role, but that does not help...
How can I give the above mentioned permissions, so that when user cust1 logs on then he can chnage his own password from the web application as long he has given his old password correctly?
I don't know there is Password filed in SQL 2000 or not ?
If there is not , then How to hidden password in database.
pls help me !
I am looking to create an ASP w/ functionality to change user's SQL password. Many do not have access to EM or Query Analyzer and need a website to visit. Has any had expirience w/ this prior?
View 19 Replies View RelatedIs there any way in SQL Server 2000 to configure password rules for SQL server logins, e.g. minimum password length, complexity etc?
Thanks!
Hi all,
I have SQL 2000 and I forgot my SA password and cannot login as administrator using windows authentication.
Is there any way to reset SA password?
"Mixed Mode" authentication is enabled.
If I change authentication mode in register to Windows only and then after restarting SQL change it back to Mixed, will it reset SA password to "null"?
Thanks in advance.
Hello, I'm running an MS SQL 2005 database which supports our entire website and it's fairly huge. I seem to have lost the sa password for the database.
I COULD get it back if there was a way to convert the SQL 2005 DB to an SQL 2000 DB, seeing as how I found a password cracker for that version. Is there anyway to convert a 2005 DB back to a 2000 DB?
Does anyone have any other ideas they might want to lay on me?
I'm kind of sick about this... I'm usually a really good note-taker; In fact, I do have the sa password recorded in an IT database that I keep. Unfortunately the password just doesn't work. I've tried the caps lock and other variations, but the password just eludes me.
Thanks for your help,
Chris
In SQL Server 2000, can you enable an option to check password retries? For example if an SQL Server ID logs incorrectly 5 times, you disable the login account.
Any help would be greatly appreciated. Thanks.
What is best way to encrypt password field in sql server 2000?.
Is there any system stored procedure to encrypt password?.
What kind of algorithm password encryption method uses?.
How would I save a users password to a table, change it to a default password and restore it if necessary?
View 3 Replies View RelatedHi all,
Are there any built-ins, utilities, ... within sql server 2000 that can be used to enforce password complexity in the database. i.e at least 8 characteres, upper and lowercase mix, includes at least on number and one punctuation (underscore,...).
I understand that this requirement can be achieved using windows authentication. Unfortunately we do not have that luxury (at the moment).
tx.
Hello, I'm running an MS SQL 2005 database which supports our entire website and it's fairly huge. I seem to have lost the sa password for the database.
I COULD get it back if there was a way to convert the SQL 2005 DB to an SQL 2000 DB, seeing as how I found a password cracker for that version. Is there anyway to convert a 2005 DB back to a 2000 DB?
Does anyone have any other ideas they might want to lay on me?
I'm kind of sick about this... I'm usually a really good note-taker; In fact, I do have the sa password recorded in an IT database that I keep. Unfortunately the password just doesn't work. I've tried the caps lock and other variations, but the password just eludes me.
Thanks for your help,
Chris
I want to set userID and Password for perticular database without affecting sql server userid and password in sql server 2000 :)
View 3 Replies View Relatedhi, all:
I installed a Sql 2000 Personal Edition in my Laptop,now I want to change my Sql 2000 sa account password.
but I can not find where I can get the default password for sa account and how to change it .
thanks
I 'completed' a DTS package which uses a file on a non-SQL server. I am about to put this into production, so it runs automatically each evening. but just realized that it won't work unless it signs onto the source file's Windows 2000 server. It works for me when I'm testing it because I am always logged on the the Windows 2000 server.
I have been trying to figure out which DTS task I need to use to establish a connection by embedding my UserName and Password. Any tips woud be apprecitaed.
Thanks,
Randy
Learning as I go....
HI!I have a little problem:I have change the administrator password (Windows 2003 Server) which MSSQL 2000 use to login.And now the SQL server can't stand up.What should I do?thx!gicio--Posted via http://dbforums.com
View 1 Replies View RelatedHi All, I am trying to connect to an SQL SERVER in a remote production server from ASP.net using following code. Dim conProd As New OleDbConnection("Provider=SQLOLEDB.1;Data Source=ServerName;UID=User Name;PWD=Password;Initial Catalog=Database")conProd.Open()I am getting following error while running this script [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied. But I am able to connect to this server using following three other ways:1) Using query analyzer2) I created DSN and performed test connection, it succeded.3) In ASP.NET -> Server Explorer -> Data Connections, I added this connection and test connection also successful.I tried to connect to this server in VB 6.0 using following code Dim conProd As New ADODB.ConnectionconProd.Open "Provider=SQLOLEDB;Data Source=ServerName;Initial Catalog=Database; Timeout=500;", "UserName", "Password" I am able to connect using this above code in VB 6.0 also.But I dont what is happeing in .NET. Please help me. I am using XP and VS .NET 2003
On my development maching, I have three different SQL Server instances:..SQL2000..SQL2005EXPRESS..SQL2005When i try to debug a stored procedure in Query Analyzer, I get thefollowing error:"Server: Msg 508, Level 16, State 1, Procedure sp_sdidebug, Line 1[Microsoft][ODBC SQL Server Driver][SQL Server]Unable to connect to debuggeron MYPCSQL2000 (Error = 0x800401f3). Ensure that client-side components,such as SQLLE.DLL, are installed and registered on MYPC. Ddebugging disablefor connection 53."Client side components _are_ installed. What gives? Any ideas?J. JespersenDenmark
View 1 Replies View RelatedHi Friends, I am trying to Upgrade my Sql server 2000 Enterprise edition with SP4 to Sql server 2005 Enterprise edition (Inplace upgrade). The Sql 2000 machine was just now installed and applied with SP4 and has only system databases I want to try configuring Log Shipping in sql 2000 and then perform some testing by upgrading it to sql 2005.........so thats why i went for sql 2000.The OS is Windows 2003 server with SP1 and has sufficient hard disk space. I knew that it is possible to perform Upgrade from Sql 2000 SP3 or later (Enterprise edition) to Sql 2005 Enterprise edition. But when I run the sql 2005 Enterprise edition Setup, I provide the instance name in the dialog box! and beneath it there is "Installed instances" box is present if i click it, it shows the version and edition of my sql 2000 instance as 8.00.194 which is nothing but Sql 2000 RTM version. Hence I am unable to proceed with the installation as it says to refer the version and edition upgrades are not matching as per the requirements........But if i open the query analyser for that instance and type
Code Block
Select @@Version or Select Serverproperty('Productlevel') it displays the o/p as SP4Also in the error log it shows as 8.02039 which is Sql 2000 SP4 I am a bit confused even though sp4 is installed i am unable to perform the upgrade ? Feel free to provide your valuable suggestionsadvice if any ?RegardsDeepak
Hello,
I currently have two servers, one is a SBS2003 server running SQL 2005 and SSRS (2005) and a 2000 SQL server. I want to extract data from the 2000 server but keep getting this error: "Remote access to report data sources and/or the report server database" is not supported in this edition of Reporting Services. (rsOperationNotSupported)
When Iooked up this error, the only information I get is telling me that I can't do this in SQL Express, I'm not sure but I think the standard SQL in SBS is at least Workgroup?? What can I do to correct this?
Thanks
J.J.
Hello all,
My name is Elizabeth. I'm currently trying to upgrade our Reporting Server to version 2005. The SRS that's currently installed on our CRM server is version 2000, and we want to upgrade that to 2005 so that we can use VS 2005 to write new reports (since SRS 2000 is not compatible with VS 2005).
So I followed the steps as on this link http://technet.microsoft.com/en-us/library/ms144267.aspx
However, I'm stuck at step# 11. As it says on the link: "If a component has a check box that is unavailable, the component does not qualify for upgrade to SQL Server 2005." I did get something like below; the check box is unavailable.
When I click on the "Detail" button on that menu, I get a message like below:
If I click on "Next" anyway from the menu, I get this error message:
I'm just wondering why it doesn't let me upgrade to 2005. The current version of SRS that's installed in our CRM server is Microsoft SQL Server 2000 Reporting Service Standard Edition. According to Microsoft link http://technet.microsoft.com/en-us/library/ms143393.aspx that edition should be upgradable.
It just crossed my mind actually; could it be because our Window Server is only using Service Pack 2, while according to that link the server has to use SP3 version or later. Please clarify me if this is the case.
Could you please help me on this one? I really appreciate it!! Thanks in advanced!!
-Elizabeth K.
Hi All,
In SQL Server 7, we had the option of opening a previously saved trace template and running it inorder to run a previously saved trace defintion repeatedly.
File > Open > Trace Definition
and choosing the Trace Name. Clicking OK would run the trace.
How do we do the same in SQL Server 2000?
File > Open > Trace Template
opens a Trace template but has only a 'Save' button and I'm therefore unable to run it.
How is it possible to run a previously defined trace repeatedly in SQL server 2000?
Thanks in advance,
Praveena
I am unable to insert record in a field which is null and unique. It does not accept NULL value again in the same field. It shows error UNIQUE KEY VIOLATION.
Please help
Hi,I have an application that's running fine on development servers (weband database-sql server 2000). I'm updating a record through a thirdparty component but I don't think the component is the problem. What'shappening is that I'm updating fields that are part of view. I'm onlyupdating fields in one table of the view and this works fine in thedevelopment environment.What happens in the production environment when I try to update(using the third party component) I get the following message:"Current recordset does not support updating. This may be a limitationof the provider or of the selected locktype."As an experiment I took the same code but removed the view, leavingonly the table I want to update as the record source. In that case theupdate worked. So it seems that something in the production databasedoesn't like me updating a view. However I can do that in the databasein the development environment.The third party component is dbnetgrid which works fine in thedevelopment environment. I can only conclude it's something about thedatabase that prevents me from updating this same table if it's in aview. I've talked to our DBA but he says there's no difference betweenthe databases. Any ideas would be appreciated.Neil
View 2 Replies View RelatedHello,
I have a query that seems to take a while to execute and I'm looking into using an indexed view to see if this helps. I use the script below to create the view but when I query it's indexability using:
(select ObjectProperty(object_id('GetMessageQueueDetails'), 'IsIndexable'))
it always return '0'.
Here is a very cut down version of the view, only selects the uid! from a single table
IF OBJECT_ID ('GetMessageQueueDetails', 'view') IS NOT NULL
DROP VIEW GetMessageQueueDetails ;
GO
IF sessionproperty('ARITHABORT') = 0 SET ARITHABORT ON
IF sessionproperty('CONCAT_NULL_YIELDS_NULL') = 0 SET CONCAT_NULL_YIELDS_NULL ON
IF sessionproperty('QUOTED_IDENTIFIER') = 0 SET QUOTED_IDENTIFIER ON
IF sessionproperty('ANSI_NULLS') = 0 SET ANSI_NULLS ON
IF sessionproperty('ANSI_PADDING') = 0 SET ANSI_PADDING ON
IF sessionproperty('ANSI_WARNINGS') = 0 SET ANSI_WARNINGS ON
IF sessionproperty('NUMERIC_ROUNDABORT') = 1 SET NUMERIC_ROUNDABORT OFF
GO
CREATE VIEW GetMessageQueueDetails
WITH SCHEMABINDING
AS
SELECT Uid
FROM dbo.MyTable
GO
I see from See http://msdn.microsoft.com/en-us/library/aa933148(SQL.80).aspx that the pre-requsites for indexed views are pretty strict, I have been through this list and think I have everything covered, except for :
"The ANSI_NULLS option must have been set to ON for the execution of all CREATE TABLE statements that create tables referenced by the view."
Is there an easy way to find out if ANSI_NULLS was ON or OFF when the table was created. If it was OFF can I do an ALTER TABLE to turn it on and will that make the view indexable? If so how do I do this with out trashing the data in the table?
Or am I doing something else wrong?
Can anybody offer any help?
Thanks
Hi,
iam having vs2005 installed on my machine and i also installed sqlserver2005 dev edition on my machine...Unable to connect to Sqlserver 2000 which is installed remotely ....Sqlserver2000 is dev edition.i cudnot find Sqlserver2000 instance when i try to search for Network database engine name .......
I feel to know how to enable remote connection on Sqlserver 2000.So tht i can access this sqlserver2000 from another machine
Hi,
I am using VS2005 and Sql Server 2000 (personal edition). I am able to connect with SqlClient Provider on Local Machine (when db server and VS2005 on same machine). But I try to connect SqlServer on different machine it is not allowing me to connect. If I use SqlOledb Provider it got connected.
Please tell me how could I connect with DB server (Sql Server 2000) from remote machine.
Hi,
I recently started using SQL 2000 Analysis Manager. I wanted to try data mining but was unable to get the Mining Model Wizard to load available techniques.
When I select a cube and "New Mining Model" I get the following error:
"Unable to get list of data mining algorithms."
"Object of provider is not capable of performing requested operation"
Please help.
Thank you very much,
Robert
I know this is old database but when I download this evaluation from microsoft website, I got problem installing it. First, I unzip it. By default, it is unzip to C:SQLEVAL. Then, I went to install it. I don't which file I should click. So, I double click the autorun file. When I did that, there is a screen, I saw the screen saying "microsoft SQL Server 2000 Evaluation version". Then, I click "SQL Server 2000 Components"
Then, it comes to next page, and I click "Install Database Server". But after I did that, nothing happens! After I click again the same thing all over again, it says "Another instance of setup is already running".
I'm using Window XP Professional. Anyone encounter this problem before? I tried to re-download the file and reinstall but also the same problem. Really need help. Thanks.