SQL Server Express And Simple Passwords
Apr 24, 2007I am moving an application from MSDE to SQL Server Express. I have having difficulty finding a way to use a simple passsword for the SQL Login. SQL Server 2005 allows this
View 5 Replies
ADVERTISEMENT
Simple Solution For Encrypting Passwords?
Aug 8, 2003I've created an internal website (ASP/vbscript) that has individual logins for employees. Since I am the only person with access to the web/database server, I am storing plain text passwords in the database (I know - bad idea). I thought we wouldn't have a problem with hackers within the company, but I was notified by an angry employee using network monitoring software (against company policy) that he can see his plain-text password being passed over the network.
So, now I have to encrypt the passwords in the database - which I obviously should have done from the start. The problem is that I am a database newbie, so I don't even know where to start. I've seen posts about RC4, but I am confused. I'm looking for something VERY simple - anyone know of an "encrypting for dummies" article? If I encrypt the passwords in the database, would I have to do anything special in my ASP code? By the way, I can't use SSL on this server, if that makes a difference.
Thanks.
SQL 2005 Passwords, Can It Be Configured To Accept Case-insensitive Passwords???
Jul 7, 2006Users were able tolog on to our SQL 2000 servers with their passwords being case-insensitive.
Now with SQL 2005 some users can't logon because SQL 2005 passwords are case-sensitive.
Can SQL 2005 be configured so that passwords are NOT case sensitive???
Thanks!
Simple SQL Server Express Question
Jun 25, 2007Hi all,I've just installed Express on my Vista notebook and I'm having a few problems.Maybe this is just a conceptual problem on my side but I expected to see a server process (in other versions of SQL server I've used there has been an icon in the server tray of the taskbar).When I open "Microsoft SQL Server Management Studio Express" I also expected to see a database instance running locally I can connect to (from other research this instance appears to be called SQLEXPRESS). There isn't one.
If I select server type "database engine" on the "connect to server" dialog there are no instances displayed in the "Server Name" field. "Browsing for others" shows nothing under "local servers" which doesn't seem right to me.If I change "server type" to "SQL SERVER COMPACT EDITION" (which doesn't seem right either as I thought "compact edition" was something else) I can have an option to create a database file
Additional information:
I downloaded SQL server express today from this url:
http://msdn.microsoft.com/vstudio/express/sql/download/. I downloaded the advanced services toolkit edition as I thought I may was well have all the bells and whistles to play around with.Any ideas?thanksJoel
Simple Trigger For SQL Server Express 2005
Jun 12, 2008I've this tableCREATE TABLE [dbo].[Attivita]( [IDAttivita] [int] IDENTITY(1,1) NOT NULL, [IDOwner] [int] NULL, [IDAttivitaStato] [varchar](1) COLLATE Latin1_General_CI_AS NULL, [IDAttivitaTipo] [varchar](2) COLLATE Latin1_General_CI_AS NULL, [IDAnagrafica] [int] NULL, [Data] [datetime] NULL CONSTRAINT [DF_Attivita_Data] DEFAULT (getdate()), [Descrizione] [varchar](max) COLLATE Latin1_General_CI_AS NULL, [Privato] [bit] NULL, [LastUpdate] [datetime] NULL CONSTRAINT [DF_Attivita_LastUpdate] DEFAULT (getdate()), CONSTRAINT [PK_Attivita] PRIMARY KEY CLUSTERED ( [IDAttivita] ASC)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]) ON [PRIMARY]How Can I create a trigger for modify the IDAttività Stato field in specific situaion: if IDAttivitaTipo == OK or == NOIDAttivitaStato must be set to CPlease note that I can write in the IDAttivitaStato field (during my code operation).... but I would like also automatic update if the IDAttivitaTipo is OK or NO Can you help me for create this with a trigger?Thanks
View 2 Replies View RelatedSimple Migration From MySQL To SQL Server Express 2005?
Mar 18, 2006Normally I'd go and write a bunch of code for doing it manually... But instead of that, maybe there is a smarter way?
What I know is that you can get some kind of dump out of MySQL but I would be very surprised if that could be directly read into SQL Express ??
So if you have a few step guide to migrate from MySQL to SQL Express, I am all ears (and eyes)!
Thanks!
(Yes I am aware there is some DTS thingy for this but could not find it in the Express folders)
SQL Server Express Excruciatingly Slow With Simple Quries
Mar 10, 2008
I am running simple queries against test SQL Express installation and they take a very long time to return data. I have two SQL Express instances installed on colleagues' machines to which I connect for my testing and both exhibit the same problem. The setup is Windows XP SP 2 with 2 GB RAM and 3.6 GHz CPU. I am querying a table with around 7000 records and my query is simply SELECT TOP 1000 * FROM MyTable. It takes over 10 seconds to return the recordset!
I have done the research and found posts, which talk about AUTO_CLOSE option, indexes, query execution plan, etc. I have done everything those posts recommend, but performance is still terrible. All the instances have SQL 2005 SP2 applied.
I also found that the query runs fast locally on each SQL Express instance, the problem seem to happen when I am trying to pull the data over the network.
I am really not sure what else to look for.
Thank you,
Michael
Simple Test Winforms App: Login Failed For User Sa - Sql Server Express
Jan 25, 2008I've installed sql server 2005 on a customer's machine.
I have a very small "connection tester" app C# (2005) winforms app, which I use to verify connection strings. This app has been working for years. I am using the sa account to login with in this test app just to keep things simple. I am using Sql Server Authentication.
When I try to connect, I get a "login failed for user sa". I'm absolutely certain that I have the password correct.
Sql Server Express is setup in mixed mode, and I have all the tcp/ip settings correct ( as far as I know ).
I think if it was a tcp/ip thing, it wouldn't find the machine, as opposed to saying Login Failed.
I'm running out of things to look at.
The machine has .NET 3.5 installed. The connection test was written using C# 2005, .NET 2.x Could that cause a problem?
Simple Examples Of SQLCLR By Connecting To SQL Express User Instances In Management Studio Via VB 2005 Express
Sep 28, 2007Hi all,
I want to do SQLCLR by Connecting to SQL Express User Instances in Management Studio via VB 2005 Express and I have read the following articles and books:
(i) Connecting to SQL Express User Instances in Management Studio in http://blogs.msdn.com/sqlexpress/archive/2006/11/22/connecting-to-sql-express-user-insta...
(ii) Managing SQL Server Express with SQL Server 2005 Management Studio Express Edition in http://www.microsoft.com/technet/sql/2005/mgsqlexpwssmse.mspx
(iii) Chapter 16 - Going Beyand Transact-SQL: Using the SQL Common Language Rutime (SQLCLR) in Microsoft SQL Server 2005 Express Edition for Dummies
(iv) Chapter 21 - Working with the Common Language Runtime in Microsft SQL Server 2005 Programming for Dummies
(v) Chapter 4 - Introduction to Common Language Runtime (CLR) Integration in Programming SQL Server 2005 by Bill Hamilton.
I want to create an SQLCLR project "HelloWorld" by Connecting to SQL Express User Instances in Management Studio via VB 2005 Express. But I am still not sure how to get it started, because I do not understand the following things:
(1) Pipe Name for a User Instance, (2) Enabling (or Disabling) the CLR by using Transact-SQL, (3) Creating a Transact-SQL script, (4) Creating an Assembly, (5) Creating a backup device, etc. I need to see some simple examples of SQLCLR by Connecting to SQL Express User Instances in Management Studio via VB 2005 Express. Please help and tell me where in the websites I can find them.
Thanks in advance,
Scott Chang
Passwords In Sql Server 2000
Jul 23, 2005HI, How to save passwords in sql server server 2000, i mean i builddatabase that consist table of user , in this table i want to storageuser's details including their passwords. As i understand it's not goodidea to storage password like other data i mean name , last name.How to accomplish this???--Message posted via http://www.sqlmonster.com
View 1 Replies View RelatedSQL Server Does Not Save New Passwords
Mar 30, 2007Hello All, I have a problem with my database. It appears that it does not save the passwords for a login account that I have created. Every time I put in the password (using the Management Studio) it looks like the new password has been accepted. But when I look at the password using properties, the password is different. Any ideas? Thanks a lot for your help.
View 2 Replies View RelatedView Unmasked Passwords In SQL Server?
Dec 21, 2005I am moving a large number of databases to a new server. While recreating the orphaned users it takes a bit of time to hunt down the connection string in code to find out the password for the login (I didn't create the majority of the web applications). Is there a way to have Enterprise Manager display the passowrds in plain text to make my job a bit more efficient?
View 2 Replies View RelatedTransfer Logins And Passwords To Another Server
Mar 28, 2006I€™m using express edition of SQL server 2005. 9.00.1399.06 (Intel X86)
I need to transfer all SQL logins and passwords from one server to another.
The script at http://support.microsoft.com/kb/246133 (designed for sqlserver 7.0 and 2000) This script references a system table (master..syslogins) that may not exits in sqlserver 2005. I get the following error:
EXEC master..sp_help_revlogin
Msg 208, Level 16, State 1, Procedure sp_help_revlogin, Line 12
Invalid object name 'master..sysxlogins'.
Would SMO be something to try for transfering logins and passwords?
Thanks,
Karl
Transfer Passwords From Production To Test Server
Aug 8, 2002I would like to know what procedures are required to transfer passwords from my Production server to my Test server.
View 1 Replies View RelatedSQL Server 2008 :: VB Script / Connection Strings And Passwords
Nov 2, 2015We run some VB scripts to extract data from our SQL server. Within these scripts we reference a 'read only' SQL userid and it's password in the connection string.
What I want to do is remove the references to the 'read only' user and it's password from the scripts.
Could we add the user that is running the script as a SQL authenticated user (that has read only access) thereby not have to reference any passwords in our script ?
SQL Server 2005 - Changing Passwords With POLICY Enabled
Jun 22, 2007Using SQL Server 2005 SP2 std edition on Windows 2003 R2 SP2 x64 std edition I'm allowed to break the password policy.
To reproduce this behaviour as a system administrator run...
create login testuser with password='p'
This creates a login with the default of POLICY enabled ('Enforce Password Policy' check box is checked). OK, so may be system administrator is allowed to break the policy but now login as testuser and run
alter login testuser with password='t' old_password='p'
This succeeds despite obviously breaking the policy.
Surely this can't be right, I must be doing something wrong.
Any help will be greatly appreciated.
Tim Gordon-Jones
Simple Workgroup (Like Access) Use Of SQL Express ??
Feb 19, 2007Hi all,
In the past if we wanted to provide an application with simple (multi-user) database facilities, we would use an Access mdb database which we could basically xcopy deploy to the client. Share the folder across the network and apart from the limitations of mdb databases it would work !!!
With all the advancements in databases ! we have moved on to SQL Express - touted as the thing to use and the replacement for MSDE and MDB databases. But hang on a minute !! It doesn't work like that ! You can't deploy Express like we used to with MDB databases - the default Express database doesn't allow multi-access ?? and if you can't xcopy deploy the Express database. The 'user Instance' thing is useless - basically every user gets their own copy of the database !!! How many developers asked Microsoft for that one!! It's crazy!!
We just need to copy our exe files and the mdf file share across a workgroup and bingo network version of our software - it's not brain surgery - Is it! We don't need mountains of security - we need (FIRST OF ALL) easy deployment.
Please tell me I've got it wrong and you can deploy a SQL Express based application without jumping thru hoops ????
Regards
Steve
SQL 2005 Express Timeout On Simple Queries
May 5, 2007Hi everybody!
I have made a simple application with VB6 and SQL 2005 Express.
And after testing it in a network simulated with Virtual-Machine Workstation, the "real world" application was first getting slower and slower, and finally giving timeout errors.
It is even difficult to connect. The application times out always at 30 secs although the ado connection timeout was established longer (45)
I have checked on the machine where the server is installed, just in case the slow down was due to network problems, but it fail locally too.
Any help is wellcome
Simple Customers ~ Orders Table Handling Question SQL Express 2005
Dec 13, 2007
I want to refer in a table quotes to customers and itemes from another table.
here is my table list in database:
"Customers"
"PriceList"
I want to create another table which through it I can create qoutes for customers suing a collection of items in PriceList table.
for example I want to be able to create something like this:
Title:
my quote example
QuoteID:
46543
Items (retrieved from PriceList table):
370
474
456
belongsTo (a relation to CustomerID in Cstomers table):
6234876
Discount, Date, WrittenBy, etc.
how many tables do I have to use for it, and what queries I have to write, and do I have to create any special relationships?
regards
Simple Simple Linking Tables & Perform Calculation
Mar 22, 2007found it
View 3 Replies View RelatedPasswords
Feb 5, 1999Is there a way I can enable my end users to change
their own passwords within SQL 6.5 every 30 days to
something unique?
Currently, I don't see that they have the option to change
it anywhere.
Any thoughts?
Thanks!
Toni
Passwords In SQL 6.5
Mar 24, 1999I have to create some type of an sp that will force users to change
their passwords every 30 days. It sounds like I should be able to
create a simple table with the login and the password expiration date.
Then, I should create some type of function to check the expiration, get
the new password and run sp_password. Has anyone done this before?
Where would this table be created? In Master? Would that also be where
I should create this sp? Should this be an xp?
I'm fairly light on creating sp's. Can anyone suggest a starting point
for me or give any suggestions?
I would appreciate any help.
Thanks!
Toni E.
Sql/nt Passwords
May 28, 1999Does some one know of a way to use windows passwords in sql w/o having to enter them in? Like a program or sql statement?
As of now, we are having to enter them in ourselves , and would like to make our jobs easier....Thanks!!
Need Help With Passwords
Feb 6, 2005hey guyz
in the database, is there anyway to chnage the password field to * instead of showing what is inside?
Passwords
Sep 30, 2007Hi
I have SQL Server 2000 and in one of the databases we store the Application passwords as a Clear text. we would like to encrypt
these passwords so that we will pass the auditing.
Can some one please suggest a good way to encrypt these passwords.
Thanks
[HELP]passwords
Jan 7, 2007for example i will set the password as chicken
http://img515.imageshack.us/my.php?image=chickenqs6.gif
then i press ok and it seems like it works i open it right away and
http://img295.imageshack.us/my.php?image=notchickenao0.gif
^^clearly not chicken......
then,ontop of that when i open the login name is a query script its some 15 character password that everytime u open in script the code changes..
http://img401.imageshack.us/my.php?image=screenhunter04jan062317zu0.gif
any help would be greatly appreciated
PGP Files And Passwords
May 2, 2001I have a pgp file requiring a password that is emailed to me. Is it possible to set up a DTS package that will open the file (using the password), and insert the data into a table, file, etc.
TB
User Passwords
Oct 8, 2001Hello,
Is there a way to pull user id's and passwords from a database?
TIA,
Anita
Changing Passwords
Dec 5, 2000I have a problem where our developers would like to change the passwords of the SQL Logins without knowing the users old password.
The only way they can use the below syntax is that they must be a member of the SYSAdmin Server Role.
sp_password NULL, 'newpassword',Max
I need a way to allow them to change the passwords without making a user a member of the SYSAdmin Server Role.
Any thoughts would be greatly apprecitated. Thanks in advance.
Max
Sqlserver Passwords
Dec 1, 2004Hello all,
Is there anyway to tell in sqlserver when a users' password has been changed?
User Passwords
Apr 27, 2004Is there a way that I can prevent SQL Authenticated users from changing their passwords?
View 6 Replies View RelatedPasswords For The Logins
Jun 1, 2004Hi All,
Sql server 7
There are set of logins in sql server some are NT authentication and some are sql server authentication. How can i retrieve the passwords for both these logins.
TIA
Adil
Users And Passwords
Apr 11, 2008How can we change the passwords of users in 2005 and in 2000
View 2 Replies View Related