SQL Server Database Setup Problem
Dec 28, 2007
Good Afternoon all,
We just migrated to Microsoft SQL Server 2005 about six months ago. Everything seems went on very well. Database itself and most of our programs which access the database all are working just fine. But recently we encountered a database accessing problem. We have a program which reads database using a login ID and a password. The program works fine when programmer A log onto the server and run it. But when another programmer, say programmer B, log onto the server and try to run the same program with the same login ID and password. Accessing to the database was denied. Both programmer A and B have the same Database Adminstrator privilege. What did we do wrong is setting up the database? Can any of you help us solving the mystery? Thanks. Happy Holiday.
Tom Lin
View 2 Replies
ADVERTISEMENT
Mar 26, 2007
I run setup using GUI. It upgrades all components of the existing installation w/out any problems except the last component. That is, it proceeds with the installation of SQL Server Database Serices and at the end fails to shut down the SQL Server and aborts the installation reporting the following:
"Service 'Computer_NameSQLEXPRESS' could not be stopped. Verify that you have sufficient privileges to stop system services. The error code is (16386)".
I am running Windows XP SP2 with both .NET 2.0 and .NET 3.0 installed on it. I am logged in as a system administrator.
The most puzzling to me things are:
- the setup starts AND STOPS w/out any problems SQL Server Reporting Services and SQL Server VSS Writer (thus finding enough privileges for both).
- the setup starts the SQL Server w/out any problems (thus it finds enough privileges to START A SYSTEM SERVICE) and then fails as described above 'lucking privileges".
During installation before failing the setup displays following:
"Run as Normal User. RANU instance Shutdwon in progress: MSSQL$SQLEXPRESS". The "normal user" puzzles me too, unless the SQL Server itself is meant here.
Any suggestions would be appreciated. I can provide the installation log file as well.
Thanks.
View 5 Replies
View Related
May 22, 2008
I would appreciate help on how to setup database on server B when SQL Server is located on server A of a multi-server network. I am a novice.
View 3 Replies
View Related
Nov 2, 2007
Hello Everyone,
I am new to the creation of SQL Servers and databases, I have only use SQL statements in code in the past, and I have encountered a problem in my first SQL Server 2000 setup...
I am trying to setup a database in SQL Server 2000 called Equipment, which will contain multiple tables corresponding to the names of different equipment being used. I am able to create that just fine, but my problem occurs when I try to create login names for that database. For the database to correctly interface with another program already in use I need two login names, "Equip" that has full access and "Equip_ReadOnly" that is unable to delete, insert, or update. The problem is that I wish for those two login names to be accessing the same tables within the database, so that any changes made by Equip will be seen by Equip_ReadOnly. However, when I try to do this I end up with two sets of tables, one owned by Equip and the other owned by Equip_ReadOnly.
I am able to accomplish what I want in SQL Server 2005 by using the dbo schema to contain the tables and then have Equip and Equip_ReadOnly as users of the dbo schema, but for this project I am unable to use SQL Server 2005. So far I have been unable to figure out how to accomplish this task using SQL Server Enterprise Manager. So, does anyone have any ideas or insight into this particular problem? I am stuck at the moment and any help would be appreciated.
Thanks
P.S. If this was the wrong forum to post this question in, please point me to the correct forum. Thanks Again.
View 5 Replies
View Related
Jan 2, 2008
hi all
i get the following message error when installing sql server 2005 express :
<< sql server setup could not connect to the database service for server configuration the error was :[microsoft][gestionnaire de pilotes odbc] source de données introuvable et nom de pilote non spécifié >>
is there any help
thanks and best regards
View 6 Replies
View Related
Jun 4, 2006
OS: XP-SP2
Not able to install SQL Express 2005.
------------------------------
SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]SSL Provider: The certificate chain was issued by an authority that is not trusted.
Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29515&EvtType=lib%5codbc_connection.cpp%40Do_sqlScript%40OdbcConnection%3a%3aconnect%40connect%40x80090325
Needles to say, above link is useless..
I had managed to install previously, but ran into problems while trying to upsize an MS-Access database, I've tried everything from creating certificate to hacking away at the registry...Log-on with a different account, etc...Anybody knows how to get around this?
Here's part of the log file:
Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Sat Jun 03 20:09:53 2006
Machine : YANICK
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : e:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_YANICK_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : YANICK
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : e:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_YANICK_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : YANICK
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.1399.06
Install : Successful
Log File : e:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_YANICK_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine : YANICK
Product : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install : Successful
Log File : e:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_YANICK_MSXML6_1.log
--------------------------------------------------------------------------------
Machine : YANICK
Product : SQL Server Database Services
Error : SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]SSL Provider: The certificate chain was issued by an authority that is not trusted.
Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
--------------------------------------------------------------------------------
Machine : YANICK
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.00.1399.06
Install : Failed
Log File : e:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_YANICK_SQL.log
Last Action : InstallFinalize
Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}SSL Provider: The certificate chain was issued by an authority that is not trusted.
Error Number : 29515
--------------------------------------------------------------------------------
View 3 Replies
View Related
Jun 7, 2005
Hi All, I'am looking for a software (Installer) to create a setup file to install a SQL Server Database just like the one in the Reports Starter Kit, when you install it a dialog will guide you to instaal the database thats what i'am looking for. Anybody knows how can i do that or is there a software that can help me doing that.Best Regards.Wafi Mohtaseb
View 2 Replies
View Related
May 9, 2008
Hi,
Can I setup SQL 2005 and SQL 2000 database server on the same machine?
View 5 Replies
View Related
Mar 20, 2015
We have log shipping for databases from production to back office (BO) environments for users to run reports. In preparation for moving a back office environment to a different server, we want to setup an addition log shipping environment, let’s call it BO2, same as the BO. One of the challenges we had was the amount of time it would take to get the full backup from production to BO2 due to the size of the database. It would take days just to transfer the full backup.
Solution:Let’s just say the database being logged shipped is DB123. Instead of using the full backup of DB123 from production, we use the mdf and ldf of DB123 from current log shipped database on the BO to setup the additional log shipping on BO2.
Steps:1.Setup the directory structure for the undo file (tuf) on the BO2 server same as the BO server.
Note: The undo can be moved to different drive after the log shipping is setup.
2.Stop SQL services on the BO server.
3.Copy the undo file (tuf), mdf, and ldf files of the log shipped database, DB123, from server BO to server BO2.
Note: Keep these files as main copies because they will be used multiple times. Do NOT copy files to where you’ll put the new database files.
4.After the files are copied, start SQL services on BO.
5.On the BO2 server, create an empty database DB123 with database name, file_id, logical names, physical names exactly the same as the ones on the BO server.
Note: Make the size of mdf and ldf small so it doesn’t take long to create the database.
6.Stop SQL Services on the BO2 server.
7.Overwrite the new mdf and ldf files of the empty database DB123 with the mdf and ldf files that were copied over from BO.
8.Start SQL services on BO2.
Note: If the file_id, logical names and physical names are not matching up, the database will be in suspect mode.
9.Do a backup of DB123 with COPY_ONLY.
10.Drop DB123 on BO2 after backup is complete.
11.Use the full backup from previous step to setup log shipping of DB123 on BO2.
Note: Below was the LiteSpeed syntax that was used
exec master.dbo.xp_restore_database @database = N'DB123' ,
@filename = N'F:SQL BackupsDB123_FULL.slsfull',
@filenumber = 1,@with = N'STATS = 10',
@with = N'STANDBY = N''C: MSSQLDataROLLBACK_UNDO_DB123.trn''',
@affinity = 0,@logging = 0
12.Stop SQL services on BO2.
13.Again, overwrite the mdf, ldf and undo file (tuf) of DB123 on server BO2 with mdf, ldf, and undo file (tuf) from BO.
14.Start SQL services on BO2.
15.Replay transaction log from PRD
Note: You can change the location of the undo file by copy the current undo file to the new location and point to new location in “STANDBY” parameter. DO NOT do cut and paste of undo file but do copy and paste.
It works on Microsoft SQL Server 2008 R2 (SP2) - 10.50.4033.0 (X64) . I have not tried it on SQL Server 2012 yet.
In steps that stop/start SQL services, you can bring the database offline/online.
In a way, this is doing detach/attach a log shipped database.
View 0 Replies
View Related
Jul 23, 2005
How to Deploy SQL server Database to another PC, How to create apackage that craetes Database as well as ODBC driver for accessing dataat enduser PC, using .Net VB
View 2 Replies
View Related
Oct 15, 2007
Hello Everyone,
I am developing a asp.net application using sql server 2005 with full-text searching.
Question
I am looking for a recommnded hardware setup for the databases server. I know there is no one answer but I am wondeirng if there is a microsoft guide that I could use.
If anyone has any experience, i would welcome your comments as well.
I am estiamting that the full text index will be about 2-4 gb in size, most of the activity will be full-text searches.
Also, any good benchmarks out there for full-text searching or sql server tps ?
Thank you for your time!!
View 1 Replies
View Related
Jun 1, 2007
I have create database name and userid and password and now i want to create tables on sql server through enterprise manager. I have problem to connect registration.
View 4 Replies
View Related
Feb 20, 2008
I am setting up a web server and I'm having some issues with database connections. I am running Windows Server 2k3 and SQL Server 2005. The error I get is when I attempt to connect to the database, it's the following:
Cannot open database "dbReseacher" requested by the login. The login failed. Login failed for user 'userRes'.
The following is my connection string:
<add name="RESEARCHER" connectionString="Data Source={Sql Server}; Server=THRALL2; Database=dbReseacher; Uid=userRes; Pwd=password;"/>
In SQL Server Management Studio, the user userRes is listed under Security -> Logins, but it is not listed under Database -> dbResearcher -> Security -> Users. Originally it was listed under both and this didn't solve the problem.
Please let me know if you any ideas or questions that I can answer. Thanks a lot.
-Richard
View 1 Replies
View Related
Apr 8, 2015
My company is migrating all their servers to a new data center and I get to specify what we need for the db servers.
We've got a 22 prod servers (mainly physical) with a couple of TB of data on sql 2000 to 2012.
We expect to move to sql2014, and consolidate and virtualise where ever possible.
But I'd like start with specifying an overall architecture for this: some Best Practices to guide the build at a server and an installation level
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
May 28, 2015
I've been asked to create a new SQL server and restore an old server's DBs to the new server.
I'd like to generate a list of the DB names using powershell to distribute to their creators, in case some of these DBs are no longer needed.
View 2 Replies
View Related
Apr 24, 2015
I am running a number of SQL instances on my PC. Within the network, I have think server with various System Center components. For compatibility reasons, some features of System Center 2012 R2 had to be delegated to different SQL databases. My question is, because there is now more than one IP address on my system, and each instance of SQL is assigned to its own IP, is there a way to setup DNS and SQL so the namespace points to the desired IP address? For Instance:
MSSQL2008 instance is set to run on = 11.12.13.1
MSSQL2012 is set to run on = 11.12.13.2
IN DNS:
A Record: Mike-PC = 11.12.13.1
A Record: Mike-PC = 11.12.13.2
If I want to use MSSQL2008 by specifying Mike-PC as the DNS name, how would I do that with 100% accuracy? If there is another way to get the job done, I am more than willing to approach this differently.
View 3 Replies
View Related
Feb 23, 2007
SP2 refuses to install for the Database Engine because the previous upgrade did not complete?, i.e. it detects a suspended installation. The same thing happened to me when I installed SP1. I then remember opening the maintenance dialog and completing the setup, after which SP1 installed just fine.
When I try to do the same thing this time, Im presented with the ?complete the suspended installation? option, which when I run it reports the installation completed successfully. However, in reality the installation still remains in suspended mode for whatever reason. If I reboot and open the maintenance dialog, Im still presented with the ?complete the suspended installation? option. Ive even tried to run it more than once, but it doesnt help. Needless to say, SP2 still refuses to install.
I don't know why the installation is in a suspended state. I know every part of SP1 installed successfully in the end, and the computer never crashed during the installation. I've been using it every day since then, without any problems. All other parts of SP2 did install successfully.
I created a feedback entry on Microsoft Connect, where you can find the log files created by Windows Installer. The URL is:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=259606
Any ideas what I can do to resolve this problem?
View 1 Replies
View Related
Aug 7, 2007
Hello All,I tried to set the access permissions for debugging stored procedure by reading the articlehttp://msdn2.microsoft.com/en-us/library/w1bhybwz(VS.80).aspxandhttp://technet.microsoft.com/en-us/library/ms164014.aspxI have tried to add the role to sysaminas follows1)SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_NAME = 'sp_sdidebug'(to find the sp)Error:--The stored procedure not found2)sp_addsrvrolemember 'Developmentswati.jain', 'sysadmin' though this is executed successfuly . Error is still persisting
Cannot debug stored procedures because the SQL Server database is not setup correctly or user does not have permission to execute master.sp_sdidebug.
View 3 Replies
View Related
Jun 3, 2008
I need to setup a new database with a .mdf file. Name of the database will be “socc? and username=socc1 and password=abcdefg .
Should I create a new databse with name "socc" and restore it with the .mdf file ? How do I create the required username and password ?
Does the .mdf file take care of everything?
View 4 Replies
View Related
Oct 11, 2007
Hi ,
I have a situtation where the business user wants to store the Historical Data along with the current data for Subject areas.
As a DBA i have been asked to tell them whether we need two separate set of databases for current Data and one for historical Data or just one structure holding both the current and Historical data , the current data is used downstream by many number of applications can you please guide me as to which approach would be better to take ]
One structure holds all and have indexed views for current data
separate structure for current and historical data
can you please tell me the Pros and cons of each approach.
View 1 Replies
View Related
Feb 7, 2007
I am trying get a database setup in my new install of VS 2005. I have a project on one PC where I just have VS2005 installed and i am able create a website, go to the APP_DATA folder and add a database. On another PC I have VS 2005 installed and then I installed SQL server 2005. Now I fail to connect to ??? when I try and enter the sercuity page of webconfig or try to add a database when I open the APP_DATA folder. There have been many things done on this PC between the install of the two mentioned packages and trying this database creation. However, I feel that something related to the install of SQL Server 2005 after VS 2005 has done something unexpected. Or, I need to manage something between the SQL Express version that got loaded with VS 2005 and the subsequent install of SQL Server. I just don't know what to look for at this point.
View 1 Replies
View Related
Jun 14, 2008
Okay,
I downloaded SubText and thought that I had it fully setup until I got an error at the beginning of the Install. I get the following error:
View 3 Replies
View Related
Dec 20, 2003
I have MSDE installed on my machine as was wondering what the NETSDK is in the following commands.
@rem Uncomment the following line for MSDE
@rem set DBNAME=(local)NETSDK
set DBNAME=(local)NETSDK
Thanks,
Bob H
View 1 Replies
View Related
Jul 23, 2005
I have a couple questions I hope someone might be able to answer, orrather point me in the correct direction.I am an independant developer and I am working on a small CRM for smallbusinesses. Nothing fancy, but built with c# and the .NET framework.In my study of other CRM's like Microsoft, Clarify, and Misc I havenoticed something things that I do not understand.1. When using a database, are customers and the customerscases/problems kept in seperate tables?2. When logging notes and misc, how is text formatted/kept in thedatabase. I see notes inside cases that are formatted and keep theformatting after the cases are written the the DB.Thanks for any info, and I am sure I am asking more then simplequestions.
View 4 Replies
View Related
May 18, 2007
Hello,
Our product has a MDF file included with the setup, this needs to be attached at the current SQL Server (Express or not).
Where can we copy the MDF file during setup so it can be attached successfully ? We need a place where the account SQL Server is running under has write permissions.
Please help !
Thanks
View 3 Replies
View Related
Jan 14, 2008
Hello,
I have aquired Windows XP Embedded. I went to install the Database, with SQL Server 2005 Express Edition and it said that MSDE 2000 or higher is required. I found in the MSDN library that one may use SQL Server 2005 Express to install the database, however, the installation is not finding my SQL Server instance, please help!
View 5 Replies
View Related
Dec 4, 2007
SQL location:
When I create the setup for the Teacher Starter Kit( Created with Visual Basic) (Click Once Setup) and install it in someone else computer, I can not find the SQL database ( in sense of opening it and tweak it in case i need to). the program works fine and store data, but where is the database?!! that I can not find. can you help me please? or explain.
Later On I would need to instal the ClickOnce setup of this application on a server in so everyone can reach it. is the the ClickOnce setup sufficient for this task. and will the database be added to the SQL SERVER databases ?
Please advice ...
Thank you.
RM
View 4 Replies
View Related
Feb 6, 2008
Hi,
I currently have a single Access database with the following information:
* A bunch of lookup tables
* A bunch of "main tables"
* A "snapshot" of our entire portfolio created from various joins using the main tables and lookup tables. This "snapshot" is about 22MB and is deleted and recreated sometimes on a daily basis. I compact the database regularly to keep the size down. There are other snapshots.
The snapshots are creates by various Access queries and there are various VBS / VB6 codes that either modifies the data or formats/dumps data from this database into Excel.
I'm planning on upsizing this to a SQL 2005 server and am planning on this:
1 database with the lookup tables
1 database with the "main tables"
1 database with the snapshots
All the databases set to auto-shrink...
Is this the best way to approach this?
The VBS / VB6 modules will be eventually migrated to VB.NET and ASP.NET
Many thanks for sharing your knowledge.
View 1 Replies
View Related
Jan 23, 2002
Hello,
How does one setup the connection to an external SQL/DB2 database? Any help would be appreciated.
Thanks,
Faustina
ifedif@mail.nih.gov
View 1 Replies
View Related
Jul 15, 1999
I am new to SQL Server 7 and am not sure how to handle setting up/importing FoxPro databases. The consultants that setup the database before me have combined all of the FoxPro databases into one big database in SQL server. The reasoning was that for user applications to have access to different databases in SQL they would need a connection for each database they are using, so if all the data is put into one database then the user would only have one database connection instead of 6 or 7.
Does this make sense to anyone? Someone else thought that this might have been true is SQL Server 6.5 but not in SQL Server 7.0.
Any help will be appreciated.
Mike
View 1 Replies
View Related
Nov 28, 2007
Hi, I'm having an issue setting up Database Mirroring. The environment here could be an issue.
I'm trying to set this up using 2 different servers both are SQL Ent Edition SP2, windows 2003. I'm not using a witness at this time. The 2 servers do not belong to a domain. They are both in workgroups.
I can setup the endpoints and everything up to the point just before I start mirroring. The issues happen when I go to start mirroring. It gives me a nasty error "please use a FQDN to establish the endpoints. The problem here is I dont have any FQDN for these servers since they're in a Workgroup.
So, my question here is and I haven't found anything stating that you can't set up mirroring in a workgroup environment but is it possible? I'm assuming since its yelling at me for a FQDN that I can't. Is there any other ways to implement mirroring without a domain?
Thanks for your time, help!
View 10 Replies
View Related
Sep 18, 2007
Hello,
We have vendor that is implementing an employee self serve application for current and potential employees (employment applications). There is a web server in our DMZ that has the application installed but also on the server is a SQL database that has names and social security numbers. This server will also query the backend accounting server for earnings statements and W2s. We have a Cisco ASA as the firewall and SSL to protect client authentication from the Internet. There is no SSL between the web server and the accounting server. The fact that the SQL database on the web server containing SSN associated with names concerns me. It seems that none of this information is masked or encrypted and can be seen if the server was to ever be compromised.
My idea of such a service involves a web server that queries the backend database over SSL and presents the information to the user over SSL. No personally identifiable information would be resident on the web server at all, just a facade. That is not the case and it is not what we described to them as to what we want.
It seems they have installed it the only way they know how which is not secure, or maybe it is, that's why I am here. They have installed this at numerous locations and they actually wanted any and all ports open between the web server and the backend accounting server. It took us a while to get them to follow the rule of least privilege but we essentially had to do it ourselves.
Also on our main webserver for our Internet site I found the test database they used almost 2 years ago to test this application along with names and SSN. This was before I arrived and there is no encryption or authentication for this server. Is this good secure practice? All my training says no but it is hard to believe a mutli-million dollar organization is this ignorant. I guess it shouldn't surprise me, TJX didn't pay attention either.
I saw this thread which provide some good information but I am not a database admin and I am not familiar with SQL services, etc.
My questions are: Is their implementation secure? Does anyone know where I can find more info regarding web services and HIPAA? I read where 2 firewalls are required but would like documentation to show. Any suggestions on how to implement this securely?
Thanks for the help,
Mike
View 3 Replies
View Related
