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 Authentication

Have Server2003, IIS6 with multiple websites, sql2000, and just installed
reporting services. After making my first simple report with graph to see how
this works (XP pro), I published to the server. But, I was the only one able
to see it using the server name. So, I changed the permissions on the
reportServer and reports under IIS Default website to allow IUSR_serverName
to read/execute and enabled anonymous access with IUSR_serverName.
Now, if I want to deploy update to report to web I have to take off the new
IUSR permissions and then put them back. And, only folks within the company
could get to the report - dns is done at the firewall.
So, I made a virtual directory under IIS within the web called Reports, and
made sure the permissions on the virtual directory were set to read/execute.
Now, if I use a dial-up and a url similar to below, I'm told the user
doesn't have permissions to view the page.
http://www.mydomainname.com/reports?%2freports%2fwnchngrads&rs:command=render
I've probably done a thousand things wrong - anybody willing to enlighten me?
Thanks so much.Have you found the answer to the issue? I'm interested to hear what
your status is because I'm having the same problem as well.
Thanks
janetb <janetb@.discussions.microsoft.com> wrote in message news:<16B90326-C1D2-44E6-AD5B-C64CC21373FE@.microsoft.com>...
> Have Server2003, IIS6 with multiple websites, sql2000, and just installed
> reporting services. After making my first simple report with graph to see how
> this works (XP pro), I published to the server. But, I was the only one able
> to see it using the server name. So, I changed the permissions on the
> reportServer and reports under IIS Default website to allow IUSR_serverName
> to read/execute and enabled anonymous access with IUSR_serverName.
> Now, if I want to deploy update to report to web I have to take off the new
> IUSR permissions and then put them back. And, only folks within the company
> could get to the report - dns is done at the firewall.
> So, I made a virtual directory under IIS within the web called Reports, and
> made sure the permissions on the virtual directory were set to read/execute.
> Now, if I use a dial-up and a url similar to below, I'm told the user
> doesn't have permissions to view the page.
> http://www.mydomainname.com/reports?%2freports%2fwnchngrads&rs:command=render
> I've probably done a thousand things wrong - anybody willing to enlighten me?
> Thanks so much.|||Angela,
Nope. I've tried a bunch of different settings at this point. Including
the
<ReportServerExternalURL>http://www.domain.org/ReportServer</ReportServerExternalURL>
setting, but nothing has worked. I've posted at: aspfree; sqlteam,
sqljunkies, ms, sqlmagazine - nobody is answering. Even watched a few more
ms webcams. Frankly, I probably won't be able to use the product if I can't
find a solution.
I'll do my best to come back and let you know if somebody helps me out.
jb
"Angella" wrote:
> Have you found the answer to the issue? I'm interested to hear what
> your status is because I'm having the same problem as well.
> Thanks
> janetb <janetb@.discussions.microsoft.com> wrote in message news:<16B90326-C1D2-44E6-AD5B-C64CC21373FE@.microsoft.com>...
> > Have Server2003, IIS6 with multiple websites, sql2000, and just installed
> > reporting services. After making my first simple report with graph to see how
> > this works (XP pro), I published to the server. But, I was the only one able
> > to see it using the server name. So, I changed the permissions on the
> > reportServer and reports under IIS Default website to allow IUSR_serverName
> > to read/execute and enabled anonymous access with IUSR_serverName.
> >
> > Now, if I want to deploy update to report to web I have to take off the new
> > IUSR permissions and then put them back. And, only folks within the company
> > could get to the report - dns is done at the firewall.
> >
> > So, I made a virtual directory under IIS within the web called Reports, and
> > made sure the permissions on the virtual directory were set to read/execute.
> >
> > Now, if I use a dial-up and a url similar to below, I'm told the user
> > doesn't have permissions to view the page.
> >
> > http://www.mydomainname.com/reports?%2freports%2fwnchngrads&rs:command=render
> >
> > I've probably done a thousand things wrong - anybody willing to enlighten me?
> >
> > Thanks so much.
>|||"janetb" <janetb@.discussions.microsoft.com> wrote in message
news:16B90326-C1D2-44E6-AD5B-C64CC21373FE@.microsoft.com...
> Have Server2003, IIS6 with multiple websites, sql2000, and just installed
> reporting services. After making my first simple report with graph to see
how
> this works (XP pro), I published to the server. But, I was the only one
able
> to see it using the server name. So, I changed the permissions on the
> reportServer and reports under IIS Default website to allow
IUSR_serverName
> to read/execute and enabled anonymous access with IUSR_serverName.
> Now, if I want to deploy update to report to web I have to take off the
new
> IUSR permissions and then put them back. And, only folks within the
company
> could get to the report - dns is done at the firewall.
> So, I made a virtual directory under IIS within the web called Reports,
and
> made sure the permissions on the virtual directory were set to
read/execute.
> Now, if I use a dial-up and a url similar to below, I'm told the user
> doesn't have permissions to view the page.
>
http://www.mydomainname.com/reports?%2freports%2fwnchngrads&rs:command=render
> I've probably done a thousand things wrong - anybody willing to enlighten
me?
> Thanks so much.
>
Having the same problem, too. Any updates?
Thanks!
Ken|||Ken,
Nothing concrete yet, but I'm at least talking to folks on the Minsasi
website and on SQL magazine. If I get anything concrete, I'll post here for
both you and Angela.
Thanks,
Janet
"Ken" wrote:
> "janetb" <janetb@.discussions.microsoft.com> wrote in message
> news:16B90326-C1D2-44E6-AD5B-C64CC21373FE@.microsoft.com...
> > Have Server2003, IIS6 with multiple websites, sql2000, and just installed
> > reporting services. After making my first simple report with graph to see
> how
> > this works (XP pro), I published to the server. But, I was the only one
> able
> > to see it using the server name. So, I changed the permissions on the
> > reportServer and reports under IIS Default website to allow
> IUSR_serverName
> > to read/execute and enabled anonymous access with IUSR_serverName.
> >
> > Now, if I want to deploy update to report to web I have to take off the
> new
> > IUSR permissions and then put them back. And, only folks within the
> company
> > could get to the report - dns is done at the firewall.
> >
> > So, I made a virtual directory under IIS within the web called Reports,
> and
> > made sure the permissions on the virtual directory were set to
> read/execute.
> >
> > Now, if I use a dial-up and a url similar to below, I'm told the user
> > doesn't have permissions to view the page.
> >
> >
> http://www.mydomainname.com/reports?%2freports%2fwnchngrads&rs:command=render
> >
> > I've probably done a thousand things wrong - anybody willing to enlighten
> me?
> >
> > Thanks so much.
> >
> Having the same problem, too. Any updates?
> Thanks!
> Ken
>
>|||Great! I'll certainly do the same. Thanks so much, Janet!
Ken
"janetb" <janetb@.discussions.microsoft.com> wrote in message
news:3FAAD6BF-4273-46B9-BF2D-285C92824312@.microsoft.com...
> Ken,
> Nothing concrete yet, but I'm at least talking to folks on the Minsasi
> website and on SQL magazine. If I get anything concrete, I'll post here
for
> both you and Angela.
> Thanks,
> Janet
> "Ken" wrote:
> > "janetb" <janetb@.discussions.microsoft.com> wrote in message
> > news:16B90326-C1D2-44E6-AD5B-C64CC21373FE@.microsoft.com...
> > > Have Server2003, IIS6 with multiple websites, sql2000, and just
installed
> > > reporting services. After making my first simple report with graph to
see
> > how
> > > this works (XP pro), I published to the server. But, I was the only
one
> > able
> > > to see it using the server name. So, I changed the permissions on the
> > > reportServer and reports under IIS Default website to allow
> > IUSR_serverName
> > > to read/execute and enabled anonymous access with IUSR_serverName.
> > >
> > > Now, if I want to deploy update to report to web I have to take off
the
> > new
> > > IUSR permissions and then put them back. And, only folks within the
> > company
> > > could get to the report - dns is done at the firewall.
> > >
> > > So, I made a virtual directory under IIS within the web called
Reports,
> > and
> > > made sure the permissions on the virtual directory were set to
> > read/execute.
> > >
> > > Now, if I use a dial-up and a url similar to below, I'm told the user
> > > doesn't have permissions to view the page.
> > >
> > >
> >
http://www.mydomainname.com/reports?%2freports%2fwnchngrads&rs:command=render
> > >
> > > I've probably done a thousand things wrong - anybody willing to
enlighten
> > me?
> > >
> > > Thanks so much.
> > >
> >
> > Having the same problem, too. Any updates?
> >
> > Thanks!
> > Ken
> >
> >
> >