Newbie question about SQL Server 2005

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.

Use SQL Server 2005 Management Studio to connect to your databse on server. And after that you can import the databse from local database.|||Thank you, but is there any tutorials explaining this in more detail ?|||

Hi,

This tutorial might prove useful on the issue of migrating databases:

http://msdn2.microsoft.com/en-us/library/ms188032.aspx

Cheers

|||

The tutorial may help.

http://aspnet.4guysfromrolla.com/articles/050907-1.aspx

Newbie Question - Service Manager / Win 2003

Hi,

I'm running a Microsoft Windows 2003 Server computer, which is using a MS SQL server to feed our office application, OfficeTalk.

Due to the extreme size of the database, we have decided to install an external 1TB drive, and move the database to it.

The difficult bit we're finding is how to make it so that the service loads the new data source.

In other words, how do you use Service Manager to parse an argument to dbsvr.exe in order to change the database location?

Regards,
Matthew.Hi Mathew and welcome to TSDN MSSQL forum,

If you have an agreed maintenance slot where you can take the MSSQL server down, I would suggest do the following:

Back everything up
using enterprise manager detach on the database you want to move
copy the database to the new location
using enterprise manager attach the database by browsing to the new location.

If you get problems, backout by detaching the database in the new location and attach the old one.

Suggest you also try it out on a test DB, northwinds etc before you go for it for real..

Regards Purple

Newbie Question

I am replacing the computer expert in my company who just died until we get a replacement. I made some reports using the old database using the wizard. I am trying to get it to kick out reports in HTML and when I try building the program I get this error "The project cannot be deployed because no target server is specified. Provide a value for the TargetServerURL property in the property pages for this project.". What do you think the problem is?

Please read this section in MSDN: http://msdn2.microsoft.com/ms159270.aspx

The TargetServerUrl describes the URL of the report server you want to deploy your reports to. Right-click on the report project and open the properties dialog to find the TargetServerUrl.

-- Robert

|||I need it to deploy on the local host and not the internet as that is against company policy. I tried using c:\localhost\path and http:/localhost\path and that didn't work either.|||

Assuming you have a report server installation on the local machine, using http://localhost/reportserver should work.

-- Robert

sql

newbie question

i need to import data to excel from an sql db. the sql db is on a server,
excel will be on a remote computer. I'm quite happy to use access as an
intermediary if needed. i would also like to be able to write from excel to
sql is poss. although it this if tricky then i might well concentrate on
importing.

is any of this possible? if so is it hard? and can anyone point me to any
decent resources.

many thanksSearch for DTS packages in the SQL Books Online.
That should help you with what you want to do.

>i need to import data to excel from an sql db. the sql db is on a server,
> excel will be on a remote computer. I'm quite happy to use access as an
> intermediary if needed. i would also like to be able to write from excel
> to
> sql is poss. although it this if tricky then i might well concentrate on
> importing.
> is any of this possible? if so is it hard? and can anyone point me to any
> decent resources.|||Hi strawberry ,
U can try through import external data wizard from excel... Try it out.
Reg
Arijit|||For an alternative try this also

http://sqljunkies.com/WebLog/madhiv...7/27/16233.aspx

Madhivanansql

Newbie needs help

I set up the MS SQL Desktop server engine on my computer.
I successfully set up a database and the table structure using a query
utility. My Visual Studio logs in to the server using a system account that
magically exists.

but...

I can't make my web application log in to the database. I can't configure
the connection string to connect. I can't figure out how to create new
authorized user accounts that might work either. The SQL desktop engine is
a black box.

I'm stuck. How do you work this thing?

Bob

--== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==--
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
--= East and West-Coast Server Farms - Total Privacy via Encryption =--Robert Dickow wrote:
> I set up the MS SQL Desktop server engine on my computer.
> I successfully set up a database and the table structure using a
query
> utility. My Visual Studio logs in to the server using a system
account that
> magically exists.
> but...
> I can't make my web application log in to the database. I can't
configure
> the connection string to connect. I can't figure out how to create
new
> authorized user accounts that might work either. The SQL desktop
engine is
> a black box.
> I'm stuck. How do you work this thing?
> Bob
> --== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet
News==--
> http://www.newsfeeds.com The #1 Newsgroup Service in the World!
120,000+ Newsgroups
> --= East and West-Coast Server Farms - Total Privacy via Encryption
=--

---------
Dim lsConn ' ConnectionString for database
Dim ladoConn ' Database connection

' Server connection
lsConn = "Provider=sqloledb;" + _
"Data Source=<ServerName>;" + _
"Database=<DatabaseName>;" + _
"UID=<UserID>;" + _
"PWD=<Password>"

' Connect to the database
Set ladoConn = CreateObject("ADODB.Connection")
ladoConn.Open(lsConn)
---------

HTH
--
David Rowland
http://dbmonitor.tripod.com

Newbie Install question

HI,
I am new to Sql Reporting Service and I have a Newbie question. I have VS.Net installed on one Computer and SQL Server installed on a server. When I install SQL RS, Do I install it on both, my development computer and the SQL Server (windows Server)? And what VER can I put on both computers (if I have to install it on both)? Should I put Enterprise on the Server (Sql server and windows server) and Developer on the VS.Net computer? Or can I put Enterprise on both?
Thank you,
AndreWell, that depends on what you want to do. :) If you want the design app
then you have to install RS on the machine with VS. For the server
components you can install on any machine that has access to a SQL machine.
It is not a requirement that SQL and RS be on the same box.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"andre@.online.nospam" <andreonlinenospam@.discussions.microsoft.com> wrote in
message news:7D4A0AF2-17B5-447A-9042-FF56434C6353@.microsoft.com...
> HI,
> I am new to Sql Reporting Service and I have a Newbie question. I have
VS.Net installed on one Computer and SQL Server installed on a server. When
I install SQL RS, Do I install it on both, my development computer and the
SQL Server (windows Server)? And what VER can I put on both computers (if I
have to install it on both)? Should I put Enterprise on the Server (Sql
server and windows server) and Developer on the VS.Net computer? Or can I
put Enterprise on both?
> Thank you,
> Andre
>|||Thanks.
Is there any reason that I would need the Server components on my VS.Net machine? Or installing the Server components on the SQL server will do the trick?
FYI
I have both a Sql server running windows server 2003 and IIS, and a Development machine.|||There is no need to put the server components on the VS.Net machine. Some
companies will not allow IIS and SQL on the same box so they will put RS
server components on another machine.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"andre@.online.nospam" <andreonlinenospam@.discussions.microsoft.com> wrote in
message news:EAF2855F-B8D7-4074-999F-BB8EB7BE1E36@.microsoft.com...
> Thanks.
> Is there any reason that I would need the Server components on my VS.Net
machine? Or installing the Server components on the SQL server will do the
trick?
> FYI
> I have both a Sql server running windows server 2003 and IIS, and a
Development machine.
>

newbie can't connect

Windows XP pro, SQL Server 2000 developers edition installed on the =
client computer.
Installed SQL Server using all defaults except changed detination drive =
and folders to D:
Now the server does not run. I get the following error:
SQL Server registration failed...
SQL Server does not exist or access denied.
I'm trying to use "Windows authentication", which I assume means that =
when I log onto my Windows computer that that's the only login =
information that SQL server needs (that's how it seemed to work on my =
notebook).
What do I start to look for to solve this problem?
TIA.Is the SQL Service actually running ? If you run the following from the
command line does it connect
osql -S(local) -E
This assumes you installed a default instance. You can check this by running
Start>Run services.msc
Check for services starting with MSSQL. If you have one called MSSQLServer
then you have a default instance, if the service has a dollar ($) sign in it
e.g. MSSQL$INST01 then you have a named instance and connect like so
osql -S(local)\INST01 -E
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Karl" <kthompson@.pine-grove.com.nospam> wrote in message
news:eER5eb5$DHA.1036@.TK2MSFTNGP10.phx.gbl...
Windows XP pro, SQL Server 2000 developers edition installed on the client
computer.
Installed SQL Server using all defaults except changed detination drive and
folders to D:
Now the server does not run. I get the following error:
SQL Server registration failed...
SQL Server does not exist or access denied.
I'm trying to use "Windows authentication", which I assume means that when I
log onto my Windows computer that that's the only login information that SQL
server needs (that's how it seemed to work on my notebook).
What do I start to look for to solve this problem?
TIA.

Newbie backup question

Hi, am really new to all of this, so please be gentle. :)

On computer A (the server) I have SBS2k3 with SQL server 2k. On computer B (the workstation) I have MS Office/Access. I have created a couple of access projects on the workstation that have tables, stored procedures, etc.. in a couple of database on the server. Now I need some kind of backup plan.

I backup the Access projects on removable USB drives plugged into the workstation. I'd like to do scheduled backups of the databases on the server and also copy those backups to the USB drives on the workstation.

I've read that I can use Enterprise manager on the server to do scheduled backups to any drive on the server. I figure if I do that to a shared folder on the server that I can then copy that backup via the workstation and save a copy of it to the USB drive on the workstation.

1 - Do you see any problems with this scheme?

2 - Does the backup from enterprise manager really back everything up (table structures, stored procedures, etc...)?

3 - Assuming that I cycle between onsite and offsite USB drives on the workstation, if the place burned down and I had to rebuild the machines from scratch, is the backup saved to the USB drive mentioned above going to contain everything I need to recreate my databases on new blank hardware (after a fresh install of SBS2k3 and SQL server, of course)?there are many ways of doing this.
1. create a shared on the serverA (i.e. c:\shared -> \\serverA\shared)
2. create a sql job to backup your db:
backup database [your_db]
to disk 'c:\shared\your_db.bak'
with init
3. on your workstation, you can just create a windows schedule to connect to \\serverA\shared and copy the backup.

In general, I think it's a bad idea to try to schedule a backup job on the server to backup to your workstation usb drive. This can be done but is not really reliable. You have a regular backup job on the server and do copy/pull of the backup file as needed.|||Thanks.

No, I wasn't planning to schedule a task on the server to backup directly to the workstation's USB drive. I figured I'd do that manually from the workstation, since I don't always have one of the USB drives turned on. But I was planning to do a scheduled backup on the server to a folder on the server. (probably in the middle of the night)

> backup database [your_db]
> to disk 'c:\shared\your_db.bak'
> with init

So, that will backup everything, including the table structures and stored procedures, so the database can be recreated on a different computer in addition to being able to restore on the same one?|||The BAK file should contain everything. However, you shouldn't take anyone here's word for it. Create a backup of "DatabaseName", then take that BAK file and restore it to "NewDatabaseName". See if the restored database contains what you want. You can delete it after that, but then you'll know for sure what you'll get.