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?
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.
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 RelatedOkay,
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:
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
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 RelatedHello,
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
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!
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
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.
Hello,
How does one setup the connection to an external SQL/DB2 database? Any help would be appreciated.
Thanks,
Faustina
ifedif@mail.nih.gov
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
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 don’t 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!
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
Hello room,
I am newbie to Database mirroring.
I have 3 window server 2003 running in window virtual server 2005.
Server1 of sql 2005 instance:
-- SQLDev01
Server2 of sql 2005 instance:
-- SQLDev02
Serve3 of sql 2005 instance:
-- SQLDev03
The servers are running on DC and the sql servers was setup with Window authentication mode only.
Also, All the sql instances'services are running under single domain user name.
e.g: sqladmin.
I have tried to setup manually and t-sql and both running into some issues.
Can anyone help and share t-sript to setup database mirroring.?
Thanks for the help.
TJ
when i try to establish mirroring with the below command i am getting an error..
alter database SharePoint_AdminContent_c32bc-190-4-b1-1cab
set partner = 'tcp://mirror-server.3000';
go
the error :
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '-'.
i am not sure why it's throwing an error..any help would be appreciated...
thanks
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
Im a beginner in ASP.NET and SQL. Please tell me how to run and paste a few tags on "SQLCMD T-SQL execution command line utility" (90ToolsBinn). Its SQL Express 2005. I cant paste a tag of an ASP.NET beginners site http://www.asp.net/GuidedTour/default.aspx). I cant set up a data base without doing it.
When attempting to run this installer (SQLCMD T-SQL execution command line utility), I get the DOS screen but not the 1> command prompt. If I leave the screen alone, the DOD command window closes after about 5 seconds.
"C:Program FilesMicrosoft SQL Server90ToolsinnSQLCMD" -S "machine-nameSqlExpress"
If I retry the prompt, same thing happens. Attempts to Paste the script are unsuccessful, and the DOS command screen closes on it's own.
Tank you very much,
nuno vieira
Hi:
I am looking for a Step-by-Step document for setting up and configuring of database mirroring if one is available. I have gone through BOL and found some related documentation but want to see if a step-by-step document is available. If so can any one please direct me to the resource.
Thank you
AK
I have XP Pro SP2 with MDAC 2.8.1022. It had a problem so I tried to reinstall MDAC and got a Fatal Setup Error. This setup does not support installing on this operating system. I downloaded MDAC 2.8 1177 and get the same error.
I thought of uninstalling/reinstalling SP2, but this is a 2 month old Dell Latitude 610 with factory installed XP. There is no Windows Service Pack 2 option listed in the Control Panel > Add/Remove Programs.
There's some other strange things, so I wonder if they are related.
1) I have Paul set up as an administrator account. Some folders like MSSQL show that account with no permissions. I grant all the permissions to Paul for that folder. I come back later and the permissions are gone.
2) I deleted 20 files in Explorer, but 7 of them did not go away. I deleted those 7 again and they instatnly reappeared. I deleted those 7 again and then they finally went away.
3) I get a slow reaction time for things like Windows Explorer and opening and closing programs. This is suprising since it has 2 gig of RAM and 2.3 Gig processor. Could it be a memory handling problem that's causing OS problems. Probably, the memory didn't handle the OS installation well and the whole system is compromised now.
We're doing upgrades from SQL 2008 R2 to SQL 2014. This is blocked due to RS is installed but not configured. Our desired action is to uninstall RS and proceed with the upgrade. But when setuparp.exe is raised, it does not list all the features on the 'Select Features' page. In fact, it only lists the last 2 shared features (SQ Client Connectivity SDK and Microsoft Sync Framework). However, all items appear to be listed on the 'Select Instance' page including RS. I've seen this issue on 2 of our SQL 2008 R2 Servers already.
View 3 Replies View Relatedhow can setup constraint for the column in table in database ??
and what will sould write in the (BLOCKED EXPRESSION field ??
How can i include a express 2005 database in a setup? My program is a single user program, and i want express 2005 and the database to be installed on the users computer, when they install my program.
I am using Vb.net Visual Studio 2005, and i am using the 'Setup and deployment' template to create the setup.
Kindly Peer
We have a database with AlwaysOn enabled, where the database is getting mirrored using AlwaysOn to a secondary node in a two node cluster. Now we want to set up a DR site for that database in a different data center.
So trying to analyse what technologies. We can use for setting up the DR for that database. Can we use mirroring / replication or what's the best way of setting up DR on that database.
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 RelatedHello 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.
How do you setup replication from SQL Server 2000 to a oracle database? We want to push changes from sql sever to oracle, evertime sql server table is changed. I have a working ODBC connection. When I try setting up a push to the oracle side I can not find the subscriber In the list. Can someone point me in a direction, with a detailed way of doing this.
View 1 Replies View RelatedI'm setting it up using the directions provided by Microsoft @
http://msdn2.microsoft.com/en-us/library/ms189047.aspx
The problem I originally ran into was exactly like the one mentioned in the
following posting:
http://www.microsoft.com/technet/community/newsgroups/managed/dgbrowser/en-us/default.mspx?&query=mirroring&lang=en&cr=US&guid=&sloc=en-US&dg=microsoft.public.sqlserver.clustering&p=1&tid=95381f96-a34a-4d99-9e31-12719452a11d
I found an article online stating that this can occur of your principle
backup wasn't restored to the mirror server in NO RECOVERY mode. I missed
that step when performing the first restore, so i deleted that database and
started over using the NO RECOVERY option on the mirror restore.
The problem I've run into now is that after my restore executes and
completes, the database remains in a (Restoring...) state and never becomes
accessible.
Anyone know what causes this?
Thank you,
- Tyler
I want to restore my SQL Server 2000 database backup to SQL Server 2014.
View 4 Replies View RelatedHi,
I am successfully installed SSRS 2005 in my PC winxp sp2.
BUt while trying to configure database (Previous 5 steps are green) i get the following error.
The feature: "Using other editions of SQL Server for report data sources and/or the report server database" is not supported in this edition of Reporting Services
my database version
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
my reporting services version
ReportingServicesService!resourceutilities!9!9/26/2007-08:57:28:: i INFO: Reporting Services starting SKU: Standard
thank you in advance for any pointers.
regards
sahridhayan
I'm trying to install SQL Server Management studio 2012 on my Windows 7 (x64) standalone laptop. When I click "New SQL stand-alone installation..." it runs a Setup Support Rules check and always fails "Setup Account Privileges". I've looked into the error and I keep getting that I need to change security rules but I don't have that option in window 7. How do I get around this without having to resort to a computer running Windows Server?
I have Visual Studio 2013 premium installed along with Localdb v11. I just want to connect and manage my database engine through SSMS when developing any application.
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
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