Wont Authenticate
Jul 16, 2006
I have this website which has sql2000 database. this website is using the membership class of asp.net 2. when you run it on the localhost, no problem. after I upload it to my webhost, the usernames that I created with the membership class wont work anymore. membership class raises error "invalid username or password". i checked the database and the username are still there. that left me no option but to create another username. why is this happening? is there something wrong with the way I uploaded the mdf database file?
PLS HELP
View 3 Replies
ADVERTISEMENT
Oct 11, 2006
Here's my situation and I've spent enough time to troubleshoot. Any help would be appreciated.
1) I have a VB.NET Windows Form Application that uses SQL Server Express 2005 database.
2) The "mdf" file is a part of the application itself.
3) When the application distributed to my clients using Windows XP SP2, the "Click Once" installer automatically installs SQL Server 2005 Express [which is a pre-requisite] and copies this mdf file into the application folder.
4) The authentication mode is "Windows Integrated"
The problem is, when the application is launched [while logged in as the local system administrator in a given computer], it is unable to connect to the SQL Server.
I get the following error,
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance
Here's my connection string
Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Ragas.mdf;Integrated Security=True;User Instance=True
How do I fix this problem ?
View 6 Replies
View Related
Jul 16, 2006
I have this website which has sql2000 database. this website is using
the membership class of asp.net 2. when you run it on the localhost, no
problem. after I upload it to my webhost, the usernames that I created
with the membership class wont work anymore. membership class raises
error "invalid username or password". i checked the database and the
username are still there. that left me no option but to create another
username. why is this happening? is there something wrong with the way
I uploaded the mdf database file?
PLS HELP
View 5 Replies
View Related
Apr 4, 2007
Hi All,
I just installed SQL reporting Services 2005 on my XP Pro SP1 machine. The problem is when I try to login to http://localhost/Reports or http://localhost/reportserver using "Administrator" account it keeps prompting me the same windows login dialogbox it does not authenticate. I have tried to log in as other user too but same problem.
Can someone please guide me what could be wrong with my setup.
Thanks,
Nayan
View 4 Replies
View Related
Jun 7, 2006
win 2003 sp1 with sql 2005 enterprise.
Tried SA.. Tried AD Admin, tried local administrator. Set up in mixed mode so i tried windows and sql authen... I can log in normally with SA and the password and the windows admin account.
Nothing works, tried services off and on. Tried clearing everything
Reinstalled completely...
Only the SQL Server part fails because it requires authentication. All the other parts succeed.
I don't get a log since it just thinks im typing things wrong. Just this
06/06/2006 21:24:59.641 Authenticating user using Windows Authentication
06/06/2006 21:24:59.641 SQL Service MSSQLServer was previously running, ready for authentication
06/06/2006 21:24:59.641 SQL Agent Service SQLSERVERAGENT was not previously running
06/06/2006 21:24:59.782 User authentication failed. Please check to see if the password provided is correct or check to see if the SQL Server Instance is set to Mixed Authentication
06/06/2006 21:25:07.860 Hotfix package closed
basically this is what I get and i am forced to cancel...
Microsoft SQL Server Management Studio 9.00.2047.00
Microsoft Analysis Services Client Tools 2005.090.2047.00
Microsoft Data Access Components (MDAC) 2000.086.1830.00 (srv03_sp1_rtm.050324-1447)
Microsoft MSXML 2.6 3.0 4.0 6.0
Microsoft Internet Explorer 6.0.3790.1830
Microsoft .NET Framework 2.0.50727.42
Operating System 5.2.3790
View 7 Replies
View Related
Jun 5, 2006
We are writing an enterprise application in which the user logs in by entering their username and password in a form. The user will enter their actual Active Directory credentials. I want to pass the username and password to a stored procedure that will check for a valid user account in an Active Directory. In Sql Server 2005 I know I could write a small .NET library that uses System.DirectoryServices , register it in SQL and access it from an stored procedure.
Can it be done in Sql server 2000?
The reason we are not just autheticating in the .NET code of the application is that we found that it does not work on Windows 98 cleints, hence the need to go through sql server.
Thanks
View 1 Replies
View Related
Jun 7, 2006
I've got a windows application that needs to authenticate to the active directory.
But the only members of certain group can start the application.
for example only the administrators of the active directory can start the application.
Cheers,
Mike
View 1 Replies
View Related
Nov 22, 2006
Hi all.
M trying to create a logon form
I had something in mind but i can work it out yet
When the user wants to login into the application the value of textbox must be compared with the datafield in the sql server.
And then i want a messagebox to show up.
I created a table in sql server with 2 fields in it , User and Password.
I hope anyone could help me tnx already
View 1 Replies
View Related
Feb 4, 2008
I€™m working on an application that needs to support multiple users without log in and out of Windows. I would like to use trusted/integrated security (domainusername) so I.T. does not have to manage two accounts per operator. Is it possible to use trusted accounts (domainusername) in the SQLClient.Connection object?
Thanks!
Sean
View 8 Replies
View Related
Oct 30, 2007
On a SQL 2005 Cluster, when you move the SQL resources you generally have to kind of "reauthenticate". For example, in SSMS and after you have moved the SQL cluster resources, you run a query in SSMS and you get a connection failure. Run it again and it works.
Does anyone else notice this? I am assuming it is because the resources are now on a differen't server. But then what's the purpose of the SQL virtual server name and instance? I thought when you authenticate to SQL it's to the virtual SQL server like so... VirtualServerSQLInstance.
Can someone straighten out my poor mangled mind?
I'd like to avoid this reauthentication thing.
Thanks
View 2 Replies
View Related
Feb 26, 2004
I have a NT Group of users that need to connect to MSSQL db using integrated auth and run a stored proc. I have got this concept to work for individual windows users but not a group.
Does anyone have any ideas?
(Win XP, MSSQL 2000 SP3, Windows Group = "SQLUsers", member is "User2")
--- TSQL ---
USE master
GO
sp_grantlogin 'pcSQLUsers'
GO
sp_defaultdb 'pcSQLUsers', 'theDB'
GO
USE theDB
GO
sp_grantdbaccess 'pcSQLUsers', 'SQLUsers'
GO
GRANT EXECUTE ON [dbo].[uspThing] TO SQLUsers
GO
-- Trying to connect with OSQL.EXE:
> osql -d theDB -E
Login failed for user 'pcUser2'.
BUT.....
runing it for the individual user:
---TSQL
USE master
GO
sp_grantlogin 'pcUser2'
GO
sp_defaultdb 'pcUser2', 'theDB'
GO
USE theDB
GO
sp_grantdbaccess 'pcUser2', 'SQLUsers'
GO
GRANT EXECUTE ON [dbo].[uspThing] TO SQLUsers
GO
---- now trying to connect with OSQL.EXE as User2:
>osql -d theDB -E
1> exec uspThing
2> go
3> data....
all is fine......
I can't use the user method - to much admin... any ideas!?
PK
View 1 Replies
View Related
Sep 1, 2006
I tried using Query Notification on my computer at home:
* Win XP Pro with all the SPs and hotfixes
* SQL 2005 with SP1 qand hotfix
Query Notification worked fine.
Then I tried using it at work:
* Win XP Pro with all the SPs and hotfixes
* SQL 2005 with SP1 qand hotfix
and I see the following error in the SQL server log file and notification does not get to the client app:
----------------------------------------------------------
Date 9/1/2006 10:18:30 AM
Log SQL Server (Current - 9/1/2006 10:18:00 AM)
Source spid17s
Message
An
exception occurred while enqueueing a message in the target queue.
Error: 15404, State: 19. Could not obtain information about Windows NT
group/user 'domainmyuser', error code 0x6e.
----------------------------------------------------------
A similar error shows up in the machine's Event Log.
I am
sysadmin and full OS admin on both boxes. The difference is that the
computer at home is standalone while the one at work is part of a
domain.
What could be wrong?
View 7 Replies
View Related
Feb 2, 2007
Hi. I have a DetailsView with Bound Fields "Login" and "Password". This informations are stored in SQL database. How to solve such authorization? How to compare password stored in database against passowrd typed by user? Is this a good idea to use CustomValidator control to write some checking procedure?. Regards. Pawel.
View 1 Replies
View Related
