A Few SQLExpress Usage Questions (user Setup Related)
Dec 31, 2007
Hello
I have a windows application that connects to a SQLExpress database hosted on a shared server. The client machines will run an interface software and interact with the info within SQL The SQL database isn't huge (50 megs) and all of the info is text. The interface application isn't too complex either, it was designed using VB.net05. I have a few setup questions:
1 - Is it best to use Windows or SQL authentiaction? Currently I am using Windows authentication and I have a user group setup on the DNS that is setup as a user for the SQL database. That has worked so far, but I've only had a few users logged in at one time so far. My plan was to add all DNS accounts that will use the software to the DNS user group, thus giving them access to the SQL database.
2 - I know this gets asked a TON, but I am interested in knowing how many users I should be able to support using the current setup. I have the one user acount setup for the DNS user group. The SQL table is not huge and it is all reading and writing text. The server is running Windows Server 03 and is a couple years old (not sure of exact specs).
Thanks for any help, I am still learning my way around SQL and it's great to have such a vast amount of support for the product.
Happy New Year!
Paul
View 1 Replies
ADVERTISEMENT
Dec 1, 2006
Hi
We have a small Ethernet LAN running SBS 2003 R2. I have installed SQL Server 2005 that came with that release on the server. I did not specify a named instance.
1) What is the name of the default instance?
2) When I go to a client computer I cannot see the SQL server instance.
For example on my PC I have VS2005. If I go to Server Explorer, all I see is the local copy of SQL Server 2005 Express I have installed on my PC. I see nothing for the server. Does the server need configuring within SQL Server to allow this. Do I need to change permisions on the folders where the SQL Server 2005 files are stored.
In short, what basic steps do I need to follow to get acces to SQL Server on my server from a client.
3) If I want to create a new named instance, do I have to do Run the whole setup again? There appears to be no managemnt tool for instances of SQL server.
Thanks
Steve
View 3 Replies
View Related
Nov 17, 2005
This forum is intended for users who are new to SQL Server, and have basic usage questions. If you have setup or installation issues or questions, you should check out the Setup forum.
Thanks
View 11 Replies
View Related
Apr 30, 2007
Hello all,
Has anyone else experienced random SQL timeouts and checked the processor usage and found that processors 0 and 1's usage patterns are mirrored (when one goes up the other goes down)? We're running into this all of a sudden.
SQL 2000
fairly small db and very low usage at this time < 100 connections/hour.
only web services, SQL 2000 running on the machine, SQL 2005 is installed but currently stopped.
1GB memory
Windows Server 2003 SP 1.
2 processors (dual core) in use.
SQL Usage of the processors according to performance monitor becomes an exact mirror where proc 0 goes high proc 1 goes low, if proc 1 is 25% then proc 0 is 75%.
Thanks
Bob
View 5 Replies
View Related
Apr 1, 2006
how does one convert from sqlexpress (mdf files) to sql server 2005 and vise-versa, ie from SQL Server 2005 to SQLExpress mdf files?
View 5 Replies
View Related
Sep 8, 2006
Hi, I don't use SQL much but I need to know how to form the following query against a SQL table. I have a single table with two columns - CurrentPage and LastPage.
I need to write SQL to perform a number of iterations of a particular insert into another table, depending upon the count from CurrentPage to LastPage i've put the following Pseudocode together, but need help implementing this.
Declare counter
Set counter = currentpage
If counter > lastpage
Goto task exit loop
Else perform task - (insert string into table)
Increment counter and loop
I've been playing / reading up, but i'm getting nowhere fast -
DECLARE @Count int
DECLARE @Current string
DECLARE @Last string
SET @Current= dbSL.tblPaging_colCurrentPage
SET @Count= dbSL.tblPaging._colPagingCount
SET @Last= dbSL.tblPaging._colLastPage
WHILE @Count <= dbSL.tblPaging._colLastPage
BEGIN
PRINT 'Hello World'
SET @Count = @Count +1
END
Any help much appreciatted.
Thanks
nme
View 1 Replies
View Related
Oct 21, 2006
I have a couple questions about replication (for both 2000 and 2005 servers):
1. which system tables/dmvs/system sprocs can I look at to determine which columns of a table are being replicated?
2. which system tables/dmvs/sprocs can I call to get metadata about publishers and subscribers?
Thanks!
View 2 Replies
View Related
Dec 5, 2006
Good morning,
i have four tables
Student(iid , lname, address)
Teacher(tid, lname, salary, d_number)
Lesson_teach(tid,les_name)
Lesson_attend(iid,les_name)
Well, I'm trying to find the teachers who teach one lesson and more (e.g. only if sm teaches >= 2 lessons )
I do:
select teacher.lname
from teacher,lesson_teach
where teacher.tid = lesson_teach.tid
group by lesson_teach.tid
having count(*) >= 2)
Thanks,in advance!
View 19 Replies
View Related
Nov 7, 2006
0) We are migrating data from SQL Server 2000 OLTP design to SQL Server 2005 OLAP design.
1) We have an data flow task SSIS package.
2) We managed to send a mail with various variables & their values in subject or body of mail.
3) How do we send mail with details of Error/Warning using OnError/OnWarning events?
4) Can we have bad tables i.e where records which failed to migrate get inserted into. If yes, what are the steps to implement this.
5) Can we have a mix of in-built & custom logging. Is logging provider necessary to do logging. What logging provider to use?
6) Where are the errors that come during build, deploy, install and execute stored? Is there a log file(s) & what it their location?
7) Please post links if that is better.
View 3 Replies
View Related
Jan 10, 2007
Hi everyone,
I'm just a newbie with clustering.
We've got a 64-bit A-P cluster running with Sql25k 64-bit too.
Each node own two local network adapters. One of them (the one currently is Active) own three IP and the another one only one.
Why? From CLUADMIN I see as one of these three is set as Cluster IP Address in Active Resources. So I see the following configuration for the Active node:
Adapter 1: IP public for Active Directory
Adapter2: IP1 (reserved or ???????)
IP2 (used as SQL IP Address 1 in Active Resources)
IP3 (used as Cluster IP Address in Active Resources)
Passive node:
Adapter 1: IP public for Active Directory
Adapter2: IP (only have one ???)
Is this correct/necessary? Does anyone have similar configuration?
Thanks for your time,
View 2 Replies
View Related
May 3, 2007
I am interested in knowing the following things:
How to show total of all legend items in legend block itself as "Total".
How to show Total (say amount) in the center of donut chart.
How to customize the thickness of donut in donut chart and radius of inside and outside circle (the other thickness).
The lable markers (arrow) are not coming as a right angle arrows when i tried to use the donut and pie charts, the are coming as randomly angular lines which is hampering the beauty of the report.
Please reply as soon as possible. Thanks in advance.
View 1 Replies
View Related
Sep 20, 1999
Sorry for the previous mail.. Didnt mean to send it like that..
I have a question about replication. I have created the destination machine as the subscriber, where I created a pull subscribtion and tried to replicate I got this error.
"Subscriber must be running in perseat license moe to use this."
The cd I used to install MSSQL 7.0 is the msdn back office test platform. Where am I going wrong??/ because I never got to specify the per seat license anywhere..
The documentation says that If I can have it installed on a 95/98 box then it means I have a perseat licesne, which I was able to do..
Any any help is appreciated!!
TIA
JOsh
View 5 Replies
View Related
Dec 9, 2006
Hi all, What I'm trying to do and having a lot of trouble with is pulling how one user is related to another user from my database. I'll explain...
I set up a table called relationships that looks like this:
ID
type: int
RELID1
type: int, is the user id that initiated the relationship request.
RELID2
type: int, is the user id of the second person in the relationship.
Story
type: varchar(255), quick blerb on how they are related.
Type
type: int, a number 1-20 based on the relationship they have
Status
type: int, 1 = confirmed by second person, 0 = not confirmed
What i'd like to have pulled is a list of the people that person (for example: 70) is related to. I am having the two following problems:
1. unqid of "70" could be in RELID1 or RELID2 as they could have initiated the request or been the second person.
2. I don't want to display them selves in their own relationship listing
Example Data:
ID
1
2
3
4
RELID1
25
15
70
12
RELID2
54
70
13
8
Story
Met on the east coast
Met at walmart
Met walking
Met outside
Type
14
11
3
8
Status
1
1
1
1
Example Output:
Again assuming the current user is "70", the sql should pull: 15, 13.. but i'd like to pull their names from another table called "Users" where "15" and "13" are the UnqID's in a column called "ID".
So:
15 = Bob Smith
13 = Jane Doe
The following code works great that I got with the help on another form:
SELECT Relationship.RELID1
, Relationship.RELID2
, ReMembers.FirstName
, ReMembers.LastName
FROM Relationship
INNER
JOIN ReMembers
ON ReMembers.AccountID = Relationship.RELID1
WHERE Relationship.RELID2 = 70
UNION ALL
SELECT Relationship.RELID1
, Relationship.RELID2
, ReMembers.FirstName
, ReMembers.LastName
FROM Relationship
INNER
JOIN ReMembers
ON ReMembers.AccountID = Relationship.RELID2
WHERE Relationship.RELID2 = 70
My question is: What is the best way to set this table up? I'm not committed to any any design as of right now, but want to be sure I set it up in the most efficient manner.
Any feedback / opinions are welcome! :)
View 5 Replies
View Related
Mar 3, 2008
What's the correct way to set up impersonation & SQLExpress
Here's the error I'm getting:Cannot open database "aspnetdb" requested by the login. The login failed. Login failed for user '***ASPDATA'.
SQL Express in installed on C: aspnetdb was set up from aspnet_regsql.exe, on IIS manager - asp.net tab - edit configuration this string is there: data source=.SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true The aspnetdb is located in C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataThe ASP.Net web is on D: webconfig file has: <add name="LocalSQLServer" connectionString="Server=.SQLEXPRESS;Database=aspnetdb;Trusted_Connection=Yes;" /> <authentication mode="Windows" /> <identity impersonate="true" userName=aspdata@xxx.org password="xxx" />
Should I take a copy of aspnetdb and put it in the web app_data folder?Jess
View 1 Replies
View Related
Jan 22, 2008
I'm using the RTM version of Visual Studion 2008 and SQLServer Express.
Logged in as an administrator, I can create a connection to an mdf file and all is well.
As a normal user, attempting to create a connection gives the message "sqlservr.exe has stopped working A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available."
I have tried this with UAC turned on and turned off. The result is the same. In Services I can see that SQLEXPRESS is running, but each time I try to connect, I get the "stopped working" message.
For existing database programs that have the .mdf file stored in the project folder, I can run the program in the VS IDE on my XP machine and on my Vista machine as administrator, but not as a normal user.
I'm not looking for a workaround to make this work once, but the cause and solution to the problem. This is for an introductory VB textbook and we must be able to move a database program from one machine to another and make it work. Everything I have read says that SQLExpress should be able to do that.
Can anyone help me with this?
Judy Fraser
View 26 Replies
View Related
Aug 28, 2007
Hi All,
How can I add sql server express sp1 or sp2 into a setup project I created for an application. Normally sqlserver express is a prerequisite for my app and in deployment vs only adds sqlexpress not the sqlexpress with sp1 or sp2. I know that I need those to make my application run on vista. Any suggestion??
Thanks
View 3 Replies
View Related
Mar 11, 2004
I'm new to using SQL server and have a few setup questions.
I'm setting up a database for the company I work for. Should I setup a different database for each division in our company (e.g. accounting, project management, estimating, etc.), or should I use just one database? It seems like it would be easier to use one database so I only have to use one connection, but is this ideal? I want all the info from the different divisions to be used together, but at this point I'm confused as to how to connect different databases together, if I were to go this way.
Thanks for any input or ideas!
View 1 Replies
View Related
Sep 19, 2006
I am trying to install SQL Express, but are getting a failure. The SQLSetUp_xxxx_SQL.log contains the following information? Who can help?
Property(S): CommonFilesFolder.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128 = C:Program FilesCommon Files
MSI (s) (CC:34) [22:03:07:796]: Note: 1: 1708
MSI (s) (CC:34) [22:03:07:796]: Product: Microsoft SQL Server 2005 Express Edition -- Installation failed.
MSI (s) (CC:34) [22:03:07:812]: Cleaning up uninstalled install packages, if any exist
MSI (s) (CC:34) [22:03:07:828]: MainEngineThread is returning 1603
MSI (s) (CC:DC) [22:03:07:937]: Destroying RemoteAPI object.
MSI (s) (CC:FC) [22:03:07:937]: Custom Action Manager thread ending.
=== Logging stopped: 19/09/2006 22:03:07 ===
MSI (c) (24:40) [22:03:07:937]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (24:40) [22:03:07:937]: MainEngineThread is returning 1603
View 7 Replies
View Related
Mar 28, 2006
I got 2 questions to ask:
1. I choose Windows and SQL authentication during setup. Will this have any impact on my connection string in Dot net?
2. If I want to host my db on my computer, what other protocols do I need to enable? Currently I got shared memory on.
View 1 Replies
View Related
Jun 5, 2007
All:
I am writing an Internet/Extranet based (ASP.Net 2.0) web application that uses SQL server 2005 as the database. I am using forms authentication on my web application. I am also storing the connection string to SQL server in my web config file. The conn string is encrypted using DPAPI with entropy. I currently have created a SQL login account on my SQL server for use by the web application. This is the user ID I am using in my conn string. The reason for this is because all persons using the application will NOT have a windows login.
Here is my question: The login I created currently has defaulted to the "dbo" role and therefore has "dbo" rights to the database. I want to setup up this login account so that all it can do is execute stored procedures. I dont want this SQL login to be able to do anything else. In my application I am using stored procedures for ALL data access functions, via a data access layer in my application. Can someone guide me step by step as to how to setup this type of access for this SQL login.
Thanks,
Blue.
View 4 Replies
View Related
Oct 19, 2006
When installing SQLEXPRESS I am getting this message:
Setup failed because service MSSQL$SQLExpress is disabled for the current hardware profile. Services must be set with the current Hardware Profile logon property enabled.
Anybody knows how to fix this problem?
Eitan
View 6 Replies
View Related
Nov 21, 2007
I would like the Backup SQL user A can backup and restore DATABASE_a, what access right I need to grant to him. Although he can backup the database_a to the c:Program Files.....Database_a.BAK but he cannot restore it with some message said ''not enough security privieges..
Please quote some example right assigment so that I can replicate to our environment
Many Thanks...
View 6 Replies
View Related
Jul 23, 2005
On the other database types, there is an audit capability in that yourecord such items asfailed login attemptsattemtped access to tables user is not authroized tochanges to databse schemachanges to permissionschanges to logins (add, delete, lock, unlock, passwrod reset)All I can find in the SQLServer documentation is the reference totracking failed logins when you set up a database, plus the Profiler'sactivities.Yes, I'm taking voer my first SQLServer database and have been asked tomake sure that this database is closely monitored for inappripriateactivity.Questions:1) Does SQLServer have this capability? (Sybase has this, which iswhere I'm coming from)2) Does SQLServer do this automatically or do I have to set up theevents to be tracked as happens with Sybase?3) What commands are there for setting up these events to be tracked?Thanks in advance!
View 2 Replies
View Related
Sep 1, 2006
I am going though the ASP.NET QuickStart tutorials. One of the lessons is to add a datagrid. I am able to do that with VWD and am able to connect to the database in VWD. However when I try to execute the application I get a "Login failure" message because the user pcName/ASPNET cannot login. How do I add the ASPNET user to the SQLExpress database? There don't seem to be any administration tools that were installed with SQL Server Express 2005. Thanks in advance for the help!
View 3 Replies
View Related
Apr 15, 2007
Hi guys
I am trying to add aspnet user to sqlexpress. I am able to select the asp.net however when I click on OK button,
it is asking me to enter a name for it. COuld you tell me what name I should enter? I tried computernameaspnet didn't help?
is there better way to do this?
thanks for your help
Cemal
View 1 Replies
View Related
Feb 17, 2006
Basically I need to know how to detach a db from a user instance of SQL Express from inside a VS2005 windows forms application.
The application is project oriented and the design calls for each project to be stored in its own separate .mdf file. When the user wants to switch projects the application will detach the current database and attach a different one, containing the data for the desired project.
I have this working fine with the default (.SQLEXPRESS) db instance, but I am having a problem getting the code to work with a SQL Express user instance (also part of the specification).
I am using the SMO library to do the Detach, and this works fine with the default instance, but for the user instance I am unable to connect to the necessary (user) instance of the db server.
I have tried selecting the instance name from dm_os_child_instances on the default instance and using the dynamically generated instance name to create the Server object. I get a good instance name, but when I create the Server object, the connection fails. I have also tried issuing "sp_detach_db" on the user instance, but this fails because the db is in use.
Any ideas would be greatly appreciated...
View 3 Replies
View Related
Sep 7, 2004
Hello!
Is there any way to determine index usage statistics for a given table?
For examle, I have a table, with three indices. I need to know how many times each index was used. Is it possible?
And second part of question: I need to know, which user overloads my base with their giantic queries. Is there any way to determine, how many system resources each of user's sessions uses?
MS SQL Server 2000 Enterprise Edition.
Thank you!
View 3 Replies
View Related
May 28, 2005
Im getting ASP.Net 2.0 Beta 2 setup on my home machine to kick around
with. Im assuming this error means i have SqlServer Express
mis-configured for integrated security. if so, how do i go about
making sure that the ASPNET user has at least read access to the
Database?
Error Message wrote:
Server Error in '/Kinetic' Application.
Cannot open database "aspnetdb" requested by the login. The login failed.Login failed for user 'GAMESASPNET'.
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: Cannot open database "aspnetdb" requested by the login. The login failed.Login failed for user 'GAMESASPNET'.
Source Error:
Line 13: protected void Page_Load(object sender, EventArgs e)Line 14: {Line 15: Membership.CreateUser("jeff", [password], [email]);Line 16: }Line 17: }
Source File: c:InetpubKineticDefault.aspx.cs Line: 15
View 3 Replies
View Related
Apr 13, 2007
I'm brand new to web and ASP programming, but experienced with VB/VB.NET and SQL Server 2000 programming. I followed a tutorial and built a little website that lets you create a user login, login and change your password. I built this in Visual Studio 2005 using VB code and my understanding is that the site uses a SQLExpress database. There's an aspnetdb.mdf and .ldf file in the App_Data folder.
I want to deploy the website to a web server that is hosting SQL Server 2005, not express. Can someone be explicit about steps to take in order to do that? I've been trying a number of things in the web.config file, but I cannot seem to make a connectionstring that works. I also don't know what to do with the .mdf and .ldf files from the development server--I'm thinking they should not be deployed. Thanks for anything.
View 1 Replies
View Related
Dec 14, 2005
I have created a user in SQL Server Management Studio Express. However,
View 1 Replies
View Related
Mar 11, 2008
I'm using the methods of the Microsoft.SqlServer.Management.Smo namespace within a .NET application to create a backup file from a SQLEXPRESS database. I can then restore the database from that backup device using methods in the same namespace. Here is a snippet from the restore code:
srv = New Server("MYPCSQLEXPRESS")
db = srv.Databases("washmaster")
Dim bdi As New BackupDeviceItem(BackupFileName, DeviceType.File)
Dim recoverymod As RecoveryModel
recoverymod = db.DatabaseOptions.RecoveryModel
rs.NoRecovery = False
rs.Devices.Add(bdi)
rs.Database = "washmaster"
rs.ReplaceDatabase = True
srv.KillAllProcesses("washmaster")
rs.SqlRestore(srv)
This works great as long as I used one of the backup files that I created directly on the disk. However, my application has a utility that allows the user to copy the backup files onto another drive, such as a CD or a thumb drive and when I try to restore from the copy of the backup, I get the following exception:
....Cannot open backup device..[filename]...Operating system error 5(Access is denied.)
The reason I get this error is that the "NETWORK SERVICE" account was removed from the file permissions when the file was copied.
How can I copy a backup to another drive and preserve the "NETWORK SERVICE" account? If I can't do that, is it wise to try to add the account back to the file before using it to restore or is there a better way?
Thanks,
SJonesy
View 3 Replies
View Related
May 12, 2004
Hi all,
This is a really urgent request for some info. I can't seem to find details on this particular problem even though i can find so much general info.
I am installing SQL Server Enterprise Edition. I want to license it with 100 USER CALS. When i get to the 'Choose licensing mode' screen, I have two options:
Per Device
Per Processor
How do i set it to Per User??????
Please help.
Thanks
View 5 Replies
View Related
Feb 27, 2008
How would I go about setting up users to access my database through a windows program. Once the program is deployed on the user's desktop, they can not log into the database (via the program) using their credentials, but if the user logs on as the administrator, there is no problem. (Granted, this is in the beta development stage, so there is only one person logging in as the administrator.)
I have my setup strings in my app/config settings file, to use windows authentication, but apparently I don't have someting set up correctly. I added a specific user to my database thru SSMS and gave them the dbo as the default scheme (probably too much?), but they still can't log in.
Is this going to be a Active Directory issue, or a security issue in SQL Server 2005?
Thanks for your help
View 6 Replies
View Related
