I have a script which creates a new user. I also have a webpage which uses the DB for various reasons. In the DB config file I use the following to connect to the DB;
<ConnectionString>User Id=<username>;Password=<pword>; DataBase=<DBname>; Server = <servername>;</ConnectionString>
For the username and password I use the newly created user information but I can’t connect. However if I use “sa� to login I have no problem. Is this a case of some crappy SQL prerequisites?? i.e. automatically checking “Enforce password expiration� or “user must change password at next login� in the user properties. If I change the password for the new user in properties I can connect no problem.
Is there a way around this, so I don’t have to change the password before I can connect to the DB?
I have a script which creates a new user. I also have a webpage which uses the DB for various reasons. In the DB config file I use the following to connect to the DB;
<ConnectionString>User Id=<username>;Password=<pword>; DataBase=<DBname>; Server = <servername>;</ConnectionString>
For the username and password I use the newly created user information but I can€™t connect. However if I use €œsa€? to login I have no problem. Is this a case of some crappy SQL prerequisites?? i.e. automatically checking €œEnforce password expiration€? or €œuser must change password at next login€? in the user properties. If I change the password for the new user in properties I can connect no problem.
Is there a way around this, so I don€™t have to change the password before I can connect to the DB?
What are the minimum requirements for setting up replication ? i mean, the connection requirements, bandwidth requirements, minimum hardware and software requirements ?
Is it possible to setup a replication across the internet ?
2 questions pls: 1/ can we use bcp also in windows authentication mode or only in sql server mode. Because when i try to execute bcp from dos using windows account (my machine account since m runing XP) I get the error: The user is not associated with a trusted SQL Server connection but when i switched to sql server authentication mode. the new username and password worked well when used in BCP from command prompt.
so my question: how do i make bcp work when using win auth mode instead of sql auth mode Thanks a lot
I want to deploy an application that require the SQL Server Compact Edition 3.5 to be installed..... and I want to deploy my application with ClickOnce!
But, the problem is that I can't select "SQL Server Compact Edition" in the prerequisites of the Visual Studio Project properties... ???
I marked previous post as answered but I'm having another problem now.
The previous problem was that I didn't have some prerequisites. The log files say:
************** Report Designer component requirement <B>Explanation:</B> Visual Studio .NET 2003 is not installed. <B>Action:</B> Install Visual Studio .NET 2003, and then rerun Setup to install Report Designer. Or, continue Setup to complete the installation without Report Designer. Report Server component requirement <B>Explanation:</B> ASP.NET version 1.1 is not installed or is not registered with your Web server. ASP.Net is required for the Report Server and the Report Manager components. <B>Action:</B> Install ASP.NET 1.1, and then rerun setup to install Report Server or Report Manager components. To use the Report Server component, ASP.NET 1.1 must be registered with your Web server. Or, you can continue Setup to complete the installation without these components. For more information about ASP.NET requirements, see the Reporting Services readme file. Report size = 1082 <Func Name='SetDotNetProperties'> <Func Name='FSetupLogging'> <Func Name='CreateSetupLogCabs'> Creating Setup Logs Cab "C:Program FilesMicrosoft SQL Server80RS Setup BootstrapLOGRSStp_.cab"
The thing is that in the ADDLOCAL section of template.ini I didn't include Report Designer.
ADDLOCAL=RS_Admin_Tools,RS_BooksOnline_EN
Is Report Designer needed for the administrative tools and the books online? Or is that this too components need those prerequisites too? I ask because I installed manually without thos prerequisites, and it gave me no problems.
Can I customize it more in order if someone runs it on a different instance or server it won t fail. All he will need to replace is the username, password and make sure there is mosaikDB741.dbo.FilelistInput table and csvFilePath.csv file
We have a SQL 2008 Instance existing on active/passive cluster with 2 nodes running on Windows server 2008 R2 Ent. Edn.
Now we need to install another SQL instance on this cluster. So what are the prerequisites apart from new IP address? Do we need shared disks or can the existing disks can be utilized?
I have connected to Database using my credentials by checking remember password option. After few days I forgot my password. How can I recover the password as SQL remember it. Is there any way to recover my password instead of resetting it.
I have a package protected by a password - I am already unhappy that to get it to use the configuration file to change connection strings for the production servers I have had to hardcode the password into the config file - very insecure! However, the package now deploys correctly to the production server and will run from there OK, but NOT if scheduled as a SQL Server Agent Job. Thus is because however often I edit the command line to include the password after the DECRYPT switch (which it has prompted me for when I click on the command line tab), the Job Step will not retain it. If I open it up after I have edited it and closed it, the password has disappeared.
I know that if I run dtexec plus the code in the Command Line tab (with the password), the package runs OK.
This is driving me insane! I have read all the other posts and so I tried replacing the SSIS package step with a CmdExec step and pasting that code into there - then I get an OLEDB error..
The code I use is: DTEXEC /SQL "ImportRateMonitoringTables" /SERVER servername /DECRYPT password /CONFIGFILE "D:Microsoft SQL ServerSSISDeploymentsRateMonitoringImportTasksDeploymentImportRateMonitoringTables_Production.dtsConfig" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E
and I get
SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x8000FFFF
although the same code executes perfectly from a command prompt.
Please does anyone have any experience with a similar problem and if so, how did you get round it?
I am receiving the following error message when attempting to create a new SQL Authenticated login id.
Password validation failed. The password does not meet the requirements of the password filter DLL. (Microsoft SQL Server, Error: 15119)
I have four servers all running SQL Server 2005 SP2 on Windows 2003 Ent. SP1. Of the four servers, only one received the above error message using the same TSQL below.
CREATE LOGIN TEST_LOGIN WITH PASSWORD = 'pvif9dal' MUST_CHANGE, CHECK_EXPIRATION = ON
All four servers are in the same domain, which if I understand correctly, the password policies are therefore inherited at the OS level by the domain. The password being used is within the password policies of the domain.
I tried to install an ALLDATA database which run with SQL Server 2005 express edition. The data base fails to install becase of the following code that come up which is related to AS password requirement. The error that come up is:
TITLE: Microsoft SQL Server 2005 Setup ------------------------------
The sa password must meet SQL Server password policy requirements. For strong password guidelines, see Authentication Mode, in SQL Server Books Online.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=28001&EvtType=sqlca%5csqlcax.cpp%40SAPasswordPolicyCheck%40SAPasswordPolicyCheck%40x6d61
------------------------------ BUTTONS:
&Retry Cancel ------------------------------
I am trying to install this database in a network server operating under Windows Server 2003 R2 with SP2. If anyone knows how to solve this problem, please let me.
On the login prompt for Report Server, there is a checkbox option to "Remember my Password." I check this, login successfully... but when returning to the Report Server, I am again prompted for the password, although the user name is saved. No matter how many times I do this, the password will not save in IE7. I have tried this on 3 different computers with IE7. In IE 6, I do not even get the checkbox as an option, just the user name/password prompt. In Firefox, the password saves fine. Any ideas what would be causing this?
I have an internal Project Management and Scheduling app that I wrote internally for my company. It was written to use MySQL running on a Debian server, but I am going to move it to SQL Server 2000 and integrate it with our Accounting software. The part I am having trouble with is the user login portion. I previously used this:
PHP Code:
$sql = "SELECT * FROM users WHERE username = "$username" AND user_password = password("$password")";
Apparently the password() function is not available when accessing SQL Server via ODBC. Is there an equivalent function I could use isntead so the passwords arent plaintext in the database? I only have 15 people using the system so a blank pwd reset wouldn't be too much trouble.
I am building a website in Dreamweaver. I have tried and tried to get a connection to SQL 2005. Everything works on the web except the stuff that requires the use of my SQL tables. With OPEN_Conn ="Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=master" I get an error at the bottom of my page saying this: Microsoft OLE DB Provider for SQL Server error '80004005' Invalid authorization specification When I add a password and ID to the string the pages become very slow and I get this error: Microsoft OLE DB Provider for SQL Server error '80004005' [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Using windows authentication when logging into SQL Server doesn't have a user id or password so maybe I just don't know what to put there. I have tried a mix of all the passwords and ID's I use on this computer. Do I even have to have the user ID and password and if not how do I fix the first error? All help appreciated.
Hi All. Have a nice day. in my project asp.net web.config file has <connectionStrings> <add name="MyDbConn" connectionString="Data Source=NAVEEDSQLEXPRESS;Initial Catalog=QADB_2005;Persist Security Info=True;User ID=db1;Password=12345;" providerName="System.Data.SqlClient" /> </connectionStrings> I want to change password of database, how can i change. please can you assist. Thanks. Zahyea.
I am designing a DTS package which i need to update every so often to change the name of the source file(it's a text import). Every time that i change this, then click save, the DTS job begins to fail, with password errors. I put the password back in correctly( i still don't know why it gets lost in the first place), and click save - same result. this is getting tremendously frustrating, so i really appreciate any answers.
I need to get a password out of SQLServer 6.5. The account is a user account. I need to get the password so that I can create a development database. The DBA's that know the password have left the company, and I can not just change the password. Please HELP!!!
Recently my husband has taken the position of IS Manager for a major hotel Firm. The IS Manager that was there before him had a SQL Server which held some of the hotels data. He did not leave the SA password. How do you find out what the SA password is if you do not have it? I do not know what to tell him. Does anyone out there have any idea what he can do?
Hi! When I try to set password for any login begining from 'sa' using Enterpr. Manager or sp_password I get error message:
'Server: Msg 552, Level 16, State 1, Procedure sp_password, Line 63 CryptoAPI function 'CryptAcquireContext' failed. Error 0x80090006: Invalid Signature.' What does it mean?
Is there anyway to "get in the backdoor" if you have installed SQLserver and assigned sa a password (no other users are set up with admin rights) and then forget what the password is.
In the online doc it says you have to reinstall SQL server....isn't there any other way to get in??? For instance in SYBASE you can log on to the console and "go thru the backdoor" and issue a command from there.
I can not change the 'sa' password. It's showing the error below:
<<Error 21776: [SQL-DMO The name 'dbo' was not found in the Users collection. If the name is a qualified name, use [] to separate various parts of the name, and try again.>>
I have a DTS saved as a structered storage file.How can I provide SQL SERVER Logon ID and password for this DTS package and call it within a SP through the LOGON ID and Password?
Hi, Is there any way to show one column(password) values as ***. One of my table has password field, when you query the table it will give actual value, i wanted to show them as **** or with junk charecters. FYI..column data type is varchar(50). Thanks in advance.
Dear Friends, for one of my personal application, i forgot password, and after request, the admin send the pass word as " *2S}_P|!Krpa8P " how can i decrypt this with sql query?
