Newbie Question: WinApp Authentication To SQL 2005
Jan 5, 2007
I'm developing a small WinForms windows application (in c#). The application will communicate with an SQL 2005 server on the same network. I'm not able to use windows integrated authentication since the client users will not be members of the same domain as the SQL server.
The thing is, I want the program to Identify itself as the same user in the database regardless of witch user that is logging in. In other words, a separate SQL-access account. The complete end user authentication will be against credentials stored inside my database. In this way I will not have to create separate database users for each user.
I folks.I Have installed sql server 2005 express and choosed windowsauthentication on instalation, but i make a mistake and now i needmixed authentication, how can i modify this whithout uninstall andinstall again the application?thanks for the help.
Hi there,I have installed MS SQL Server 2005 on my machine with windows authentication. But now I want to switch the authentication mode to SQL Authentication. I am unable to switch, I can’t find the proper way to do so here in 2005.Could any one help me in doing this?Thank you,-Ahsan
Good day. Is there any version of SQL server 2005(not include Express Edition) same as SQL server 2000 Personal edition ? I am planning to install new SQL server 2005 in my pc now. I am using Windows XP SP2 now. I tried to install to Entreprise Trial version, unfortunately it just works as client. Thank you in advance.
I have two tables "Inventory" and "Product". User creates a product then assignes inventory to that product. The product table and the inventory table both have the same two fields, "GDS" and "prodID" and both share the same field and value of ProductID. I'm trying to create a trigger for the Inventory table so when the Inventory table has an update or insert, the values from Product.GDS and Product.prodID values go into the Inventory's record for Inventory.GDS and Inventory.prodID
I an having problems with the trigger as this is my first attempt in creating a trigger. I have the trigger on the Inventory table and this is what I so far which does not seem to be working, any suggestions (thanks0:
Code:
set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER TRIGGER [inv] ON [dbo].[Inventory] AFTER INSERT,UPDATE AS BEGIN SET NOCOUNT ON;
Update Inventory Set GDS = i.GDS, prodID = i.prodId From Inserted i Inner Join Inventory inv ON i.ProductID = inv.ProductID END
I am relatively new to SQL Server and I have 2005. I am developing a database with an Access ADP frontend. The development is taking place on my laptop running a separate instance of SQL Server. I am trying to put the database on the production server and I am not sure how to proceed.
My laptop is not part of the network so I need to create a file and then import it on the SQL Server instance running on the production server. I thought I could do a backup and restore, but apparently that is not working.
I can encrypt columns in sql 2005 but where do I store the key to decrypt the columns?
I can store the key in the database (or server on which the database resides) but I think that offers little security. I could store the key on another server that the sql server accesses only upon startup (though I don't know exactly how to do that). Or I could store the key on a removable drive that is read (and only needed) when the sql server starts up.
I've been working for about 20 years now with databases on other platforms but am at my first step with ADO. I created an application which is drawing as requested different forms on screen using GDI+, eventually DirectX. Now I'm at the stage of saving several infos into a Database.
For simplicity, I would like to use a database for which there is no need to install any other components. I thought of using Access Database but I realized that I'm unable to create it except from Microsoft Access which is not installed on my machine...
When programming with Clarion (SoftVelocity), apart interfacing with Oracle, any other files (ex: TopSpeed files) could be designed from within application designer and then created from scratch by resulting application. Considering this, is there any type of database that I can use and can be created/designed directly from within Visual Studio 2005?
My goal is that, if I distribute an application, I don't want my people to install anything else than simply install the resulting .exe file which should then be able to create by itself, when necessary, any database files it needs. Am I dreaming?
Hi, I have a very newbie question.I have been only developing websites locally on my computer (during my learning curve) and never actually put anything up in a server on internet, but I just bought a server from discountasp.net and an extra SQL 2005 Database.Now I need to put my database on that server (copy the local one) I know I have a connection string and username and password. But I really do not have any ideas how to do this.I would appreciate if you tell me where to start and what I should do at this stage.Thank you and have a good day.
I am trying to learn MS Sql Server and MS VB, ASP, .Net, etc., have installed SQL Server 2005 and Visual Studio 2005 on an XP Pro machine. I find fairly good MSDN help with VB & ASP stuff, but not with SQL Server. Can anyone recommend a good place to start, like online tutorials, or training, or even a good basic book that can show me how to create db’s, tables, load data, basic stuff like that?
I want to install SQL Server so at least the tables are stored on a D: drive rather than the default C: drive. If I can get the whole thing there, it would be best.
While installing S.S. the first time, I only came across one place to change a directory. After changing it, tables were still placed on the C: drive.
I am working with SQL Server 2005 Standard edition and using default settings, except for the directory of course.
I was told that XML names must not start with the letters xml (or XML, or Xml, etc) But I was able to store such data in sql 2005. Any thoughts on this one?
I'm trying to learn how to use the bcp utility... but I keep getting an error message that says: SQLState = 08001, NativeError = 2Error = [Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [2].SQLState = HYT00, NativeError = 0Error = [Microsoft][SQL Native Client]Login timeout expiredSQLState = 08001, NativeError = 2Error = [Microsoft][SQL Native Client]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. The command i'm running is: bcp territore.dbo.import in territorydata.csv -T -c territore is my database name... and dbo i think is the owner name. and the table is called Import I don't know how to check the default settings to see if remote connections are enabled. Any help would be appreciated.
When trying to connect to a SQL Server 2005 Analysis Services instance through the Excel 2007 Add-In, the ability to choose a user name/password combination rather than Windows Authentication seems to be disabled. Is there a way to do this? Thank you!
not sure if this is the right place to raise this question. If not please move this message.
I configured a Sql-Server 2005 installation -that is running on my computer for test purposes- with "Windows Authentication". I had to change my Windows password recently and it seems as if SQL-Server does not accept my account anymore. The event viewer told me that service startups failed because user or password are unkown.
Does anybody know how I may get access again? The problem seems to be that I cannot change back to my old password -unless I change it six or more times...
I developed a couple of small applications using Visual C# Express on a Sql Server 2005 Express database. I did all the connections by code, which works fine and it had to be done that way (I think) since neither of these programs support remote connections. Now at my University I'm using Visual Studio 2005, and on the Server Browser I can connect to a remote Sql Server, but I haven't found a way to change the login and password on the fly. That is I want my application to show a login form at the start and to use those username and password to perform the login on the database. If I save the username and password to the connection string (like I saw in tons of tutorials) it works fine, but that's not what I need, since the application is to be used by several different people each with their own set of permissions. Could any one shed some light or redirect me to some book, document, site which explains how to do this?
P.S: I'm using Mixed mode authentication since the network isn't Active Directory based, so most people need Sql Mode to perform the authentication.
I just removed (via Add and remove programs) SQL 2000 Server and now only have SQL 2005 left on my machine. The 2005 Server (SQLExpress?) is set up for mixed mode and I've verified that the registry setting is 2 for LoginMode, yet I'm still unable to login. This is the following error?
TITLE: Connect to Database Engine ------------------------------
Login failed for user 'drafttrackuser'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18452&LinkId=20476
------------------------------ BUTTONS:
OK ------------------------------
Naturally, the link goes no where. I've searhed this site and it seems most of the problems are either more complex (linked servers, clusters etc.) or are people who haven't set the server to work in mixed mode. I've rebooted a couple of times but the errors persist.
Hi there I sorry if I have placed this query in the wrong place. I'm getting to grips with ASP.net 2, slowly but surely! When i try to access my site which uses a Sql Server 2005 express DB i am receiving the following error:
Server Error in '/jarebu/site1' Application.
Database 'd:hostingmemberasangaApp_DataASPNETDB.mdf' already exists.Could not attach file 'd:hostingmemberjarebusite1App_DataASPNETDB.MDF' as database 'ASPNETDB'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Database 'd:hostingmemberasangaApp_DataASPNETDB.mdf' already exists.Could not attach file 'd:hostingmemberjarebusite1App_DataASPNETDB.MDF' as database 'ASPNETDB'.Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210
This is the connection string that I am using: <connectionStrings> <add name="ConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ASPNETDB.MDF;Integrated Security=True;Initial Catalog=ASPNETDB;User Instance=True" providerName="System.Data.SqlClient"/> </connectionStrings>
The database is definitly in the folder that the error message relates to. What I'm finding confusing is that the connection string seems to be finding "aranga"s database. Is it something daft?
Hi,I'm building an asp.net website using web developer express and I have a SQL 2005 express install on the same machine. Using windows security, everything works fine for development.Now I need to get it working at the client site, where the web server and SQL 2005 Express are on different machines.I'd tried using windows authentication but that didn't work, probably wasn't doing it correctly. I'd like to try SQL Authentication, at least temporarily, since I can replicate that on my laptop at home easily I think.I created a new SQL login but was really baffled by the screens showing roles and schemas, etc. There's so many roles to choose from and wasn't sure if this new login needed to own any schemas. I did turn on remote connections and mixed-mode authentication, the probably now is my asp.net membership provider login page isn't authenticating correctly, maybe my permissions are wrong on the aspnet_..... tables for users, roles, profiles, etc. Any advice?thanks,Bruce
I just created a stored procedure in SQL Server 2005 management studio. I went to my db and expanded the programmability folder then right clicked the stored procedures folder and created a stored procedure. I saved the procedure as sp_getDistance in the default folder SQL managment studio picked. Now when I went back to that stored procedure folder I did not see my stored procedure sp_getDistance, all that was there was the system stored procedure folder. Did I save the stored procedure in the wrong place, or what did I do wrong. I can't find the procedure anywhere, its just sitting in my My DocumentsSQL Server Management StudioProjectssp_getDistance.sql folder. Thanks,Kyle Spitzer
I'm a newbie on SSIS and am trying to grasp my way through this.
I am trying to copy data from a Sql Server 2000 database to a simplified table in Sql Server 2005 database.
What I want is to move the data to a staging table, then drop the main table and rename the staging table to the main table, to minimize the down-time of the data. I can't get the workflow to work, because the staging table has to exist when I run the package. I thought I could use an "Execute SQL" task to generate the table before I would run the task, but that doesn't work. Am I going about this the wrong way? Is there an optimal solution to this problem so my data can be accessible as much as possible.
I have problems with executing packages in the SQL Server 2005 and before I go into the details I would like to check, if my workflow is correct.
Can someone explain me the best way to move a package from BIDS to a SQL Server? I would like to store the packages in the SQL Server.
In addition if I login to Integration Services with SQL Server Management Studio I can see in the folder "stored packages" my package but I cannot view the folder "MSDB". Ususally I receive an error message from the named pipe provider, that I could not connect to the server (I am using Windows Authentication and my login is an administrator on the SLQ Server box)
I recently needed to upgrade a sql 2000 machine to 2005. Instead ofupgrading the sql 2000 default instance, I installed sql 2005 as aseparate named instance so we could go back to sql 2000 if necessary.The web server that connected to the new server didn't have anythingchange on it except the database ip was changed tomachinenameinstancename instead of just machinename. SQLauthentication was being used and the exact same userid/password wascreated on sql 2005. I logged into the database server using the sameuserid/pass to confirm it worked.However, when using the app, it reported "Login failure for: username"error and I confirmed 600 times over the next two hours that it was infact correctly typed in. The "State" in the sql server log indicated apassword mismatch, but again, it was correct and I verified it workedusing the sql 2005 management studio from the web server itself.Finally I had the bright idea of making the password blank, figuring itwas getting mangled somewhere in the process...That worked. So my question is, what is going on and how can I set anormal password? There is no encryption of the connection string andnothing changed in the web app between converting the machine from 2000(worked fine) to 2005 (password mismatch).
I am new to mssql I am not sure when I should use windows authentication and when to use sql server authentication I set it to sql server installation when sql server was installed I am using it right now on xp-pro platform on my home computer but I also have a website where I would like also to use it right now I do not have problem accessing the server with windows authentication but I keep getting errors when I switch to sql server authentication Your help is appreciated Dory
We have a weird problem where when one of our users selects to login into a database using Windows Authentication the wrong login information is passed to the DB.
We have two domains (A & B), each with a SQL Server running in them. We have workstations in domain B that the users log into and run Management Studio. When connecting to the database server in domain B using Windows Authentication the correct credentials are passed and everything works great (Busername). In fact, using Windows Authentication to the server in domain A works fine also (Busername) for all but one of our users. For our one user however, when logged into domain B (Busername) and using Management Studio to connect to the server in domain A with Windows Authentication she gets and error saying 'Access Denied: Ausername is an invalid login'. Before connecting the login box actualy reads 'Busername' in the username box (greyed out of course). When looking at the database log from domain A it has an entry saying 'Failed login for Ausername'.
I've never seen this before, in fact I've seen a lot of posts asking if this was possible but the answer always was it isn't. Does anyone know how to fix this?
I used JTDS to connect to SQL Server 2005 SP1(with Windows Authentication) from a Tomcat DataSource, using your usefull ntlmauth.dll, so I can use Users from Active Directory. All is ok until I must call a Stored procedure that excecute queries from a linked server table. I have the following exception message "Login failed for user 'NT AUTHORITYANONYMOUS LOGON'"
I make a lot of test, I make a Java main program invoking the sotred procedure that excecute queries on linked server using JTDS and then using Microsoft SQL Server 2005 JDBC Driver 1.2(April 2007)sqljdbc.jar and Ihave the same problem, but if we use the bridge JDBC-ODBC all works OK.
if I try to install SP 2 using SQL Server authentification (sa) it fails. The following lines appear in the file "Hotfix.log":
01/03/2007 14:08:23.859 Authenticating user using SAPWD 01/03/2007 14:08:23.875 Validating database connections using Windows Authentication 01/03/2007 14:08:24.171 Pre-script database connection failed - continuing to wait for SQL service to become responsive to connection requests ... repeated 60 times ... 01/03/2007 14:13:33.625 The following exception occurred: SQL Server reagiert nicht vor der Skriptausführung Date: 01/03/2007 14:13:33.609 File: depotsqlvaultstablesetupmainl1setupsqlsesqlsedllinstance.cpp Line: 1411
Why does it try to use Windows Authentification although I have told it to use SQL Server Authentification (Windows Authentification has been disabled in this Database Instance)?
Im currently using SQL server 2005 Management Studio. I need to export files from SQL database to Access database. But I dun think SISS is installed. Can anyone advise where to look for the file to install? Thks in advance.
