I performed an install of SSRS and SharePoint as noted in this document...
http://blogs.msdn.com/sharepoint/archive/2007/08/02/microsoft-sql-server-reporting-services-installation-and-configuration-guide-for-sharepoint-integration-mode.aspx
...with one exception I installed everything (SQL Server, Reporting
Services, and SharePoint) on the same server (single server install, don't
worry it is purely a dev box on an isolate test network, I would never do
this in production). I have rebuilt the server twice and worked though this
document each time.
Every time I get to Step 12 (on page 38-39 of the document), I try opening
the reporting services web site using the server name (e.g.
http://servername:8080/Reportserver). I get a login prompt and access denied
after three attempts. When I try to access it through localhost (e.g.
http://localhost:8080/ReportServer), I do not get the login prompt, but I do
get the typical directory browsing page with no files are listed.
All the ACLs (NTFS permissions) are set to allow Full Control for the local
admins and the three accounts being used per the document are in local admins
group. The Local admins group and the three accounts have SysAdmin rights on
SQL server.
I have done many SSRS installs but have yet to experience and issue like
this. I would greatly appreciate any of you pointing me in the right direct
to check settings. Any helpIt sounds like you are running into the Loopback Checking that was put into
place by Windows Server 2003 SP1. Follow the instructions in the KB article
listed below and that should solve your issue.
http://support.microsoft.com/kb/896861
Follow the steps under "Method 1" and see if that works.
Don't forget to reboot for it to kick in.
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
Showing posts with label files. Show all posts
Showing posts with label files. Show all posts
Thursday, March 29, 2012
Sunday, March 25, 2012
access data at web server
I have placed my sql server database files on the database webspace given for my site. I am not being able to access the tables residing in my database on web.
Same database is working well at my localhhost. Why am i getting this kind of error?
Please explain "webspace given for my site" - - is this a hosted site, etc?
what error are you actually getting?
|||The webspace given is a www folder and a db folder. www folder to keep all my aspx pages and db to keep my sqlserver database files .
The name of my database files are dodg_data.mdf and dodge_log.ldf The database name and user id given by my webhost is different , I have changed my file names according to that before uploading.
My database is not being accessed at all. I am getting inavalid object name'detail' error . detail is my tablename.
same database is working with my localhost.
I need help...........
|||
augustwind:
Please explain "webspace given for my site" - - is this a hosted site, etc?
what error are you actually getting?
The webspace given is a www folder and a db folder. www folder to keep all my aspx pages and db to keep my sqlserver database files .
The name of my database files are dodg_data.mdf and dodge_log.ldf The database name and user id given by my webhost is different , I have changed my file names according to that before uploading.
My database is not being accessed at all. I am getting inavalid object name'detail' error . detail is my tablename.
same database is working with my localhost.
I need help...........
|||You need to work with your host on this. They have most likely NOT given you a database folder for your SQL Server database, as this would imply that they would allow you to use SQL Express 2005, which most hosts would not do. They have instead likely given you space on their SQL Server. You would need to connect to this SQL Server and transfer your database to it.|||
You need to work with your host on this. They have most likely NOT given you a database folder for your SQL Server database, as this would imply that they would allow you to use SQL Express 2005, which most hosts would not do. They have instead likely given you space on their SQL Server. You would need to connect to this SQL Server and transfer your database to it.
Hi Terri,
But i am not getting it.Is keeping database files into the folder given is not enough. how can i get connected to their server. I am using connection string with username and password given by them.
Sunday, March 11, 2012
accept all directory in sql query analizer
Well I try to find why I can not run dtsrun with xp_cmdschell
but I try to put all the directory c:\program files\microsoft SQL\...
and the procedure response that he dont find c:\program command
is there a instruccion for the large names on directories that make
the correct functionality of the path?
Regards. Mirtha.I use double-quoted names in other places, maybe it works here... also, as a turn around you can use the ~ short names form.
Hope it helps,
Csar|||There is a convention for shortening a long name to an 8.3 convention but I find it hard to remember.
You can just put your pathname and executable in double quotes, i.e. "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\bcp.exe"|||Originally posted by Cesar Fraustro
I use double-quoted names in other places, maybe it works here... also, as a turn around you can use the ~ short names form.
Hope it helps,
Csar
Yes , I do but it does not work. thanks.|||Originally posted by Paul Young
There is a convention for shortening a long name to an 8.3 convention but I find it hard to remember.
You can just put your pathname and executable in double quotes, i.e. "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\bcp.exe"
Yes it works, thanks and regards.
but I try to put all the directory c:\program files\microsoft SQL\...
and the procedure response that he dont find c:\program command
is there a instruccion for the large names on directories that make
the correct functionality of the path?
Regards. Mirtha.I use double-quoted names in other places, maybe it works here... also, as a turn around you can use the ~ short names form.
Hope it helps,
Csar|||There is a convention for shortening a long name to an 8.3 convention but I find it hard to remember.
You can just put your pathname and executable in double quotes, i.e. "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\bcp.exe"|||Originally posted by Cesar Fraustro
I use double-quoted names in other places, maybe it works here... also, as a turn around you can use the ~ short names form.
Hope it helps,
Csar
Yes , I do but it does not work. thanks.|||Originally posted by Paul Young
There is a convention for shortening a long name to an 8.3 convention but I find it hard to remember.
You can just put your pathname and executable in double quotes, i.e. "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\bcp.exe"
Yes it works, thanks and regards.
Saturday, February 25, 2012
About the location of database file.
I can install the SQL Server Express in a computer and locate the database files in another computer of the same local network?
No, you cannot.
The datafiles have to be on a local drive -NOT a mapped drive, or even an UNC share. (A properly configured NAS/SAN is different though.)
Friday, February 24, 2012
about sql server
Hello,
I want to know how can use sql files or database with windows server 2003, i have many scripts that are use sql tables, but i dont know how works?
I want to know how can use sql files or database with windows server 2003, i have many scripts that are use sql tables, but i dont know how works?
can any one tell me some topics?
thank youCan you make your question more clear, probably I can help you then!|||ok,i want to use some scripts for asp that works through sql tables does not have MDB files, how can i use those files which are .sql files, should i have some software or making other configurations on my server?
tell me.
thank you|||if the .sql file are sql scripts, then your going to need SQL Server installed.
About Sql agent
Hello there,
Our sqlserver and sqlagent are started by a local administrator account, the
database backup files were stored on local disk. We are think to put databas
e
backup files to UNC directory on different server.
My question is that can we change sqlagent service to started by domain
account and let sqlserver service still run by local account? Any issue coul
d
be? Did the sqlserver and sqlagent have to run by a same account?
I really appreciate your reply,
Thanks
LionelThe one performing the backup is SQL Server, not Agent. So you need proper a
ccount for SQL Server
service. No, they don't need to use the same account. But watch out for the
mail support (SQL Mail
and Agent mail) if they don't. I prefer to have them using the same account.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"lionel" <lionel@.discussions.microsoft.com> wrote in message
news:B97BAEF8-97F8-451D-9299-6843D56483E7@.microsoft.com...
> Hello there,
> Our sqlserver and sqlagent are started by a local administrator account, t
he
> database backup files were stored on local disk. We are think to put datab
ase
> backup files to UNC directory on different server.
> My question is that can we change sqlagent service to started by domain
> account and let sqlserver service still run by local account? Any issue co
uld
> be? Did the sqlserver and sqlagent have to run by a same account?
> I really appreciate your reply,
> Thanks
> Lionel
>
Our sqlserver and sqlagent are started by a local administrator account, the
database backup files were stored on local disk. We are think to put databas
e
backup files to UNC directory on different server.
My question is that can we change sqlagent service to started by domain
account and let sqlserver service still run by local account? Any issue coul
d
be? Did the sqlserver and sqlagent have to run by a same account?
I really appreciate your reply,
Thanks
LionelThe one performing the backup is SQL Server, not Agent. So you need proper a
ccount for SQL Server
service. No, they don't need to use the same account. But watch out for the
mail support (SQL Mail
and Agent mail) if they don't. I prefer to have them using the same account.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"lionel" <lionel@.discussions.microsoft.com> wrote in message
news:B97BAEF8-97F8-451D-9299-6843D56483E7@.microsoft.com...
> Hello there,
> Our sqlserver and sqlagent are started by a local administrator account, t
he
> database backup files were stored on local disk. We are think to put datab
ase
> backup files to UNC directory on different server.
> My question is that can we change sqlagent service to started by domain
> account and let sqlserver service still run by local account? Any issue co
uld
> be? Did the sqlserver and sqlagent have to run by a same account?
> I really appreciate your reply,
> Thanks
> Lionel
>
About Sql agent
Hello there,
Our sqlserver and sqlagent are started by a local administrator account, the
database backup files were stored on local disk. We are think to put database
backup files to UNC directory on different server.
My question is that can we change sqlagent service to started by domain
account and let sqlserver service still run by local account? Any issue could
be? Did the sqlserver and sqlagent have to run by a same account?
I really appreciate your reply,
Thanks
Lionel
The one performing the backup is SQL Server, not Agent. So you need proper account for SQL Server
service. No, they don't need to use the same account. But watch out for the mail support (SQL Mail
and Agent mail) if they don't. I prefer to have them using the same account.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"lionel" <lionel@.discussions.microsoft.com> wrote in message
news:B97BAEF8-97F8-451D-9299-6843D56483E7@.microsoft.com...
> Hello there,
> Our sqlserver and sqlagent are started by a local administrator account, the
> database backup files were stored on local disk. We are think to put database
> backup files to UNC directory on different server.
> My question is that can we change sqlagent service to started by domain
> account and let sqlserver service still run by local account? Any issue could
> be? Did the sqlserver and sqlagent have to run by a same account?
> I really appreciate your reply,
> Thanks
> Lionel
>
Our sqlserver and sqlagent are started by a local administrator account, the
database backup files were stored on local disk. We are think to put database
backup files to UNC directory on different server.
My question is that can we change sqlagent service to started by domain
account and let sqlserver service still run by local account? Any issue could
be? Did the sqlserver and sqlagent have to run by a same account?
I really appreciate your reply,
Thanks
Lionel
The one performing the backup is SQL Server, not Agent. So you need proper account for SQL Server
service. No, they don't need to use the same account. But watch out for the mail support (SQL Mail
and Agent mail) if they don't. I prefer to have them using the same account.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"lionel" <lionel@.discussions.microsoft.com> wrote in message
news:B97BAEF8-97F8-451D-9299-6843D56483E7@.microsoft.com...
> Hello there,
> Our sqlserver and sqlagent are started by a local administrator account, the
> database backup files were stored on local disk. We are think to put database
> backup files to UNC directory on different server.
> My question is that can we change sqlagent service to started by domain
> account and let sqlserver service still run by local account? Any issue could
> be? Did the sqlserver and sqlagent have to run by a same account?
> I really appreciate your reply,
> Thanks
> Lionel
>
About Sql agent
Hello there,
Our sqlserver and sqlagent are started by a local administrator account, the
database backup files were stored on local disk. We are think to put database
backup files to UNC directory on different server.
My question is that can we change sqlagent service to started by domain
account and let sqlserver service still run by local account? Any issue could
be? Did the sqlserver and sqlagent have to run by a same account?
I really appreciate your reply,
Thanks
LionelThe one performing the backup is SQL Server, not Agent. So you need proper account for SQL Server
service. No, they don't need to use the same account. But watch out for the mail support (SQL Mail
and Agent mail) if they don't. I prefer to have them using the same account.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"lionel" <lionel@.discussions.microsoft.com> wrote in message
news:B97BAEF8-97F8-451D-9299-6843D56483E7@.microsoft.com...
> Hello there,
> Our sqlserver and sqlagent are started by a local administrator account, the
> database backup files were stored on local disk. We are think to put database
> backup files to UNC directory on different server.
> My question is that can we change sqlagent service to started by domain
> account and let sqlserver service still run by local account? Any issue could
> be? Did the sqlserver and sqlagent have to run by a same account?
> I really appreciate your reply,
> Thanks
> Lionel
>
Our sqlserver and sqlagent are started by a local administrator account, the
database backup files were stored on local disk. We are think to put database
backup files to UNC directory on different server.
My question is that can we change sqlagent service to started by domain
account and let sqlserver service still run by local account? Any issue could
be? Did the sqlserver and sqlagent have to run by a same account?
I really appreciate your reply,
Thanks
LionelThe one performing the backup is SQL Server, not Agent. So you need proper account for SQL Server
service. No, they don't need to use the same account. But watch out for the mail support (SQL Mail
and Agent mail) if they don't. I prefer to have them using the same account.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"lionel" <lionel@.discussions.microsoft.com> wrote in message
news:B97BAEF8-97F8-451D-9299-6843D56483E7@.microsoft.com...
> Hello there,
> Our sqlserver and sqlagent are started by a local administrator account, the
> database backup files were stored on local disk. We are think to put database
> backup files to UNC directory on different server.
> My question is that can we change sqlagent service to started by domain
> account and let sqlserver service still run by local account? Any issue could
> be? Did the sqlserver and sqlagent have to run by a same account?
> I really appreciate your reply,
> Thanks
> Lionel
>
About sp_detach_db and sp_attach_db
Hello there,
Our database data and log files were stored on UNC directory on different
server, we are thinking to use sp_detach_db and sp_attach_db to move data and
log files from UNC to local disk. Becasuse we are not familiar about
application, any minor issue could stop applicaiton. Is there any issue could
happen on sp_detach_db and sp_attach_db?
Thanks very much
Lionel
I haven't had any problems using them properly (that is, attaching databases
with sp_attach_db that were detached using sp_detach_db), but that doesn't
mean there is no possibility of issues. As with anything else, back up
first just to be on the safe side.
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
"lionel" <lionel@.discussions.microsoft.com> wrote in message
news:3E57A4A7-8D73-4DD2-B6AB-562772BF86EA@.microsoft.com...
> Hello there,
> Our database data and log files were stored on UNC directory on different
> server, we are thinking to use sp_detach_db and sp_attach_db to move data
and
> log files from UNC to local disk. Becasuse we are not familiar about
> application, any minor issue could stop applicaiton. Is there any issue
could
> happen on sp_detach_db and sp_attach_db?
> Thanks very much
> Lionel
>
|||Thanks for your reply, One of the further questions is that I noticed one of
our database owner is "unknow", I wonder why it would be happed.
when we use sp_attach_db to change the database owner from "unknow" to "sa",
any issue could be?
Thanks again
Lionel
"Adam Machanic" wrote:
> I haven't had any problems using them properly (that is, attaching databases
> with sp_attach_db that were detached using sp_detach_db), but that doesn't
> mean there is no possibility of issues. As with anything else, back up
> first just to be on the safe side.
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.datamanipulation.net
> --
>
> "lionel" <lionel@.discussions.microsoft.com> wrote in message
> news:3E57A4A7-8D73-4DD2-B6AB-562772BF86EA@.microsoft.com...
> and
> could
>
>
|||You can restore user and owner settings on the target server using
sp_change_users_login and sp_changedbowner.
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
"lionel" <lionel@.discussions.microsoft.com> wrote in message
news:2220E2B9-D439-407A-9DE3-3D18AF490F46@.microsoft.com...
> Thanks for your reply, One of the further questions is that I noticed one
of
> our database owner is "unknow", I wonder why it would be happed.
> when we use sp_attach_db to change the database owner from "unknow" to
"sa",[vbcol=seagreen]
> any issue could be?
> Thanks again
> Lionel
>
> "Adam Machanic" wrote:
databases[vbcol=seagreen]
doesn't[vbcol=seagreen]
different[vbcol=seagreen]
data[vbcol=seagreen]
issue[vbcol=seagreen]
|||Hi,
Before detaching, I recommend you to do a Full database backup of your
database. So even if Attach wont work you
could use the backup to recover the database to local hard disk using
RESTORE DATABASE command.
After that as Adam suggested you could use sp_changedbowner to change the
database owner
Thanks
Hari
SQL Server MVP
"lionel" <lionel@.discussions.microsoft.com> wrote in message
news:2220E2B9-D439-407A-9DE3-3D18AF490F46@.microsoft.com...[vbcol=seagreen]
> Thanks for your reply, One of the further questions is that I noticed one
> of
> our database owner is "unknow", I wonder why it would be happed.
> when we use sp_attach_db to change the database owner from "unknow" to
> "sa",
> any issue could be?
> Thanks again
> Lionel
>
> "Adam Machanic" wrote:
Our database data and log files were stored on UNC directory on different
server, we are thinking to use sp_detach_db and sp_attach_db to move data and
log files from UNC to local disk. Becasuse we are not familiar about
application, any minor issue could stop applicaiton. Is there any issue could
happen on sp_detach_db and sp_attach_db?
Thanks very much
Lionel
I haven't had any problems using them properly (that is, attaching databases
with sp_attach_db that were detached using sp_detach_db), but that doesn't
mean there is no possibility of issues. As with anything else, back up
first just to be on the safe side.
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
"lionel" <lionel@.discussions.microsoft.com> wrote in message
news:3E57A4A7-8D73-4DD2-B6AB-562772BF86EA@.microsoft.com...
> Hello there,
> Our database data and log files were stored on UNC directory on different
> server, we are thinking to use sp_detach_db and sp_attach_db to move data
and
> log files from UNC to local disk. Becasuse we are not familiar about
> application, any minor issue could stop applicaiton. Is there any issue
could
> happen on sp_detach_db and sp_attach_db?
> Thanks very much
> Lionel
>
|||Thanks for your reply, One of the further questions is that I noticed one of
our database owner is "unknow", I wonder why it would be happed.
when we use sp_attach_db to change the database owner from "unknow" to "sa",
any issue could be?
Thanks again
Lionel
"Adam Machanic" wrote:
> I haven't had any problems using them properly (that is, attaching databases
> with sp_attach_db that were detached using sp_detach_db), but that doesn't
> mean there is no possibility of issues. As with anything else, back up
> first just to be on the safe side.
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.datamanipulation.net
> --
>
> "lionel" <lionel@.discussions.microsoft.com> wrote in message
> news:3E57A4A7-8D73-4DD2-B6AB-562772BF86EA@.microsoft.com...
> and
> could
>
>
|||You can restore user and owner settings on the target server using
sp_change_users_login and sp_changedbowner.
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
"lionel" <lionel@.discussions.microsoft.com> wrote in message
news:2220E2B9-D439-407A-9DE3-3D18AF490F46@.microsoft.com...
> Thanks for your reply, One of the further questions is that I noticed one
of
> our database owner is "unknow", I wonder why it would be happed.
> when we use sp_attach_db to change the database owner from "unknow" to
"sa",[vbcol=seagreen]
> any issue could be?
> Thanks again
> Lionel
>
> "Adam Machanic" wrote:
databases[vbcol=seagreen]
doesn't[vbcol=seagreen]
different[vbcol=seagreen]
data[vbcol=seagreen]
issue[vbcol=seagreen]
|||Hi,
Before detaching, I recommend you to do a Full database backup of your
database. So even if Attach wont work you
could use the backup to recover the database to local hard disk using
RESTORE DATABASE command.
After that as Adam suggested you could use sp_changedbowner to change the
database owner
Thanks
Hari
SQL Server MVP
"lionel" <lionel@.discussions.microsoft.com> wrote in message
news:2220E2B9-D439-407A-9DE3-3D18AF490F46@.microsoft.com...[vbcol=seagreen]
> Thanks for your reply, One of the further questions is that I noticed one
> of
> our database owner is "unknow", I wonder why it would be happed.
> when we use sp_attach_db to change the database owner from "unknow" to
> "sa",
> any issue could be?
> Thanks again
> Lionel
>
> "Adam Machanic" wrote:
About sp_detach_db and sp_attach_db
Hello there,
Our database data and log files were stored on UNC directory on different
server, we are thinking to use sp_detach_db and sp_attach_db to move data and
log files from UNC to local disk. Becasuse we are not familiar about
application, any minor issue could stop applicaiton. Is there any issue could
happen on sp_detach_db and sp_attach_db?
Thanks very much
LionelI haven't had any problems using them properly (that is, attaching databases
with sp_attach_db that were detached using sp_detach_db), but that doesn't
mean there is no possibility of issues. As with anything else, back up
first just to be on the safe side.
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"lionel" <lionel@.discussions.microsoft.com> wrote in message
news:3E57A4A7-8D73-4DD2-B6AB-562772BF86EA@.microsoft.com...
> Hello there,
> Our database data and log files were stored on UNC directory on different
> server, we are thinking to use sp_detach_db and sp_attach_db to move data
and
> log files from UNC to local disk. Becasuse we are not familiar about
> application, any minor issue could stop applicaiton. Is there any issue
could
> happen on sp_detach_db and sp_attach_db?
> Thanks very much
> Lionel
>|||Thanks for your reply, One of the further questions is that I noticed one of
our database owner is "unknow", I wonder why it would be happed.
when we use sp_attach_db to change the database owner from "unknow" to "sa",
any issue could be?
Thanks again
Lionel
"Adam Machanic" wrote:
> I haven't had any problems using them properly (that is, attaching databases
> with sp_attach_db that were detached using sp_detach_db), but that doesn't
> mean there is no possibility of issues. As with anything else, back up
> first just to be on the safe side.
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.datamanipulation.net
> --
>
> "lionel" <lionel@.discussions.microsoft.com> wrote in message
> news:3E57A4A7-8D73-4DD2-B6AB-562772BF86EA@.microsoft.com...
> > Hello there,
> >
> > Our database data and log files were stored on UNC directory on different
> > server, we are thinking to use sp_detach_db and sp_attach_db to move data
> and
> > log files from UNC to local disk. Becasuse we are not familiar about
> > application, any minor issue could stop applicaiton. Is there any issue
> could
> > happen on sp_detach_db and sp_attach_db?
> >
> > Thanks very much
> >
> > Lionel
> >
> >
>
>|||You can restore user and owner settings on the target server using
sp_change_users_login and sp_changedbowner.
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"lionel" <lionel@.discussions.microsoft.com> wrote in message
news:2220E2B9-D439-407A-9DE3-3D18AF490F46@.microsoft.com...
> Thanks for your reply, One of the further questions is that I noticed one
of
> our database owner is "unknow", I wonder why it would be happed.
> when we use sp_attach_db to change the database owner from "unknow" to
"sa",
> any issue could be?
> Thanks again
> Lionel
>
> "Adam Machanic" wrote:
> > I haven't had any problems using them properly (that is, attaching
databases
> > with sp_attach_db that were detached using sp_detach_db), but that
doesn't
> > mean there is no possibility of issues. As with anything else, back up
> > first just to be on the safe side.
> >
> >
> > --
> > Adam Machanic
> > SQL Server MVP
> > http://www.datamanipulation.net
> > --
> >
> >
> > "lionel" <lionel@.discussions.microsoft.com> wrote in message
> > news:3E57A4A7-8D73-4DD2-B6AB-562772BF86EA@.microsoft.com...
> > > Hello there,
> > >
> > > Our database data and log files were stored on UNC directory on
different
> > > server, we are thinking to use sp_detach_db and sp_attach_db to move
data
> > and
> > > log files from UNC to local disk. Becasuse we are not familiar about
> > > application, any minor issue could stop applicaiton. Is there any
issue
> > could
> > > happen on sp_detach_db and sp_attach_db?
> > >
> > > Thanks very much
> > >
> > > Lionel
> > >
> > >
> >
> >
> >|||Hi,
Before detaching, I recommend you to do a Full database backup of your
database. So even if Attach wont work you
could use the backup to recover the database to local hard disk using
RESTORE DATABASE command.
After that as Adam suggested you could use sp_changedbowner to change the
database owner
Thanks
Hari
SQL Server MVP
"lionel" <lionel@.discussions.microsoft.com> wrote in message
news:2220E2B9-D439-407A-9DE3-3D18AF490F46@.microsoft.com...
> Thanks for your reply, One of the further questions is that I noticed one
> of
> our database owner is "unknow", I wonder why it would be happed.
> when we use sp_attach_db to change the database owner from "unknow" to
> "sa",
> any issue could be?
> Thanks again
> Lionel
>
> "Adam Machanic" wrote:
>> I haven't had any problems using them properly (that is, attaching
>> databases
>> with sp_attach_db that were detached using sp_detach_db), but that
>> doesn't
>> mean there is no possibility of issues. As with anything else, back up
>> first just to be on the safe side.
>>
>> --
>> Adam Machanic
>> SQL Server MVP
>> http://www.datamanipulation.net
>> --
>>
>> "lionel" <lionel@.discussions.microsoft.com> wrote in message
>> news:3E57A4A7-8D73-4DD2-B6AB-562772BF86EA@.microsoft.com...
>> > Hello there,
>> >
>> > Our database data and log files were stored on UNC directory on
>> > different
>> > server, we are thinking to use sp_detach_db and sp_attach_db to move
>> > data
>> and
>> > log files from UNC to local disk. Becasuse we are not familiar about
>> > application, any minor issue could stop applicaiton. Is there any issue
>> could
>> > happen on sp_detach_db and sp_attach_db?
>> >
>> > Thanks very much
>> >
>> > Lionel
>> >
>> >
>>
Our database data and log files were stored on UNC directory on different
server, we are thinking to use sp_detach_db and sp_attach_db to move data and
log files from UNC to local disk. Becasuse we are not familiar about
application, any minor issue could stop applicaiton. Is there any issue could
happen on sp_detach_db and sp_attach_db?
Thanks very much
LionelI haven't had any problems using them properly (that is, attaching databases
with sp_attach_db that were detached using sp_detach_db), but that doesn't
mean there is no possibility of issues. As with anything else, back up
first just to be on the safe side.
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"lionel" <lionel@.discussions.microsoft.com> wrote in message
news:3E57A4A7-8D73-4DD2-B6AB-562772BF86EA@.microsoft.com...
> Hello there,
> Our database data and log files were stored on UNC directory on different
> server, we are thinking to use sp_detach_db and sp_attach_db to move data
and
> log files from UNC to local disk. Becasuse we are not familiar about
> application, any minor issue could stop applicaiton. Is there any issue
could
> happen on sp_detach_db and sp_attach_db?
> Thanks very much
> Lionel
>|||Thanks for your reply, One of the further questions is that I noticed one of
our database owner is "unknow", I wonder why it would be happed.
when we use sp_attach_db to change the database owner from "unknow" to "sa",
any issue could be?
Thanks again
Lionel
"Adam Machanic" wrote:
> I haven't had any problems using them properly (that is, attaching databases
> with sp_attach_db that were detached using sp_detach_db), but that doesn't
> mean there is no possibility of issues. As with anything else, back up
> first just to be on the safe side.
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.datamanipulation.net
> --
>
> "lionel" <lionel@.discussions.microsoft.com> wrote in message
> news:3E57A4A7-8D73-4DD2-B6AB-562772BF86EA@.microsoft.com...
> > Hello there,
> >
> > Our database data and log files were stored on UNC directory on different
> > server, we are thinking to use sp_detach_db and sp_attach_db to move data
> and
> > log files from UNC to local disk. Becasuse we are not familiar about
> > application, any minor issue could stop applicaiton. Is there any issue
> could
> > happen on sp_detach_db and sp_attach_db?
> >
> > Thanks very much
> >
> > Lionel
> >
> >
>
>|||You can restore user and owner settings on the target server using
sp_change_users_login and sp_changedbowner.
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"lionel" <lionel@.discussions.microsoft.com> wrote in message
news:2220E2B9-D439-407A-9DE3-3D18AF490F46@.microsoft.com...
> Thanks for your reply, One of the further questions is that I noticed one
of
> our database owner is "unknow", I wonder why it would be happed.
> when we use sp_attach_db to change the database owner from "unknow" to
"sa",
> any issue could be?
> Thanks again
> Lionel
>
> "Adam Machanic" wrote:
> > I haven't had any problems using them properly (that is, attaching
databases
> > with sp_attach_db that were detached using sp_detach_db), but that
doesn't
> > mean there is no possibility of issues. As with anything else, back up
> > first just to be on the safe side.
> >
> >
> > --
> > Adam Machanic
> > SQL Server MVP
> > http://www.datamanipulation.net
> > --
> >
> >
> > "lionel" <lionel@.discussions.microsoft.com> wrote in message
> > news:3E57A4A7-8D73-4DD2-B6AB-562772BF86EA@.microsoft.com...
> > > Hello there,
> > >
> > > Our database data and log files were stored on UNC directory on
different
> > > server, we are thinking to use sp_detach_db and sp_attach_db to move
data
> > and
> > > log files from UNC to local disk. Becasuse we are not familiar about
> > > application, any minor issue could stop applicaiton. Is there any
issue
> > could
> > > happen on sp_detach_db and sp_attach_db?
> > >
> > > Thanks very much
> > >
> > > Lionel
> > >
> > >
> >
> >
> >|||Hi,
Before detaching, I recommend you to do a Full database backup of your
database. So even if Attach wont work you
could use the backup to recover the database to local hard disk using
RESTORE DATABASE command.
After that as Adam suggested you could use sp_changedbowner to change the
database owner
Thanks
Hari
SQL Server MVP
"lionel" <lionel@.discussions.microsoft.com> wrote in message
news:2220E2B9-D439-407A-9DE3-3D18AF490F46@.microsoft.com...
> Thanks for your reply, One of the further questions is that I noticed one
> of
> our database owner is "unknow", I wonder why it would be happed.
> when we use sp_attach_db to change the database owner from "unknow" to
> "sa",
> any issue could be?
> Thanks again
> Lionel
>
> "Adam Machanic" wrote:
>> I haven't had any problems using them properly (that is, attaching
>> databases
>> with sp_attach_db that were detached using sp_detach_db), but that
>> doesn't
>> mean there is no possibility of issues. As with anything else, back up
>> first just to be on the safe side.
>>
>> --
>> Adam Machanic
>> SQL Server MVP
>> http://www.datamanipulation.net
>> --
>>
>> "lionel" <lionel@.discussions.microsoft.com> wrote in message
>> news:3E57A4A7-8D73-4DD2-B6AB-562772BF86EA@.microsoft.com...
>> > Hello there,
>> >
>> > Our database data and log files were stored on UNC directory on
>> > different
>> > server, we are thinking to use sp_detach_db and sp_attach_db to move
>> > data
>> and
>> > log files from UNC to local disk. Becasuse we are not familiar about
>> > application, any minor issue could stop applicaiton. Is there any issue
>> could
>> > happen on sp_detach_db and sp_attach_db?
>> >
>> > Thanks very much
>> >
>> > Lionel
>> >
>> >
>>
About sp_detach_db and sp_attach_db
Hello there,
Our database data and log files were stored on UNC directory on different
server, we are thinking to use sp_detach_db and sp_attach_db to move data an
d
log files from UNC to local disk. Becasuse we are not familiar about
application, any minor issue could stop applicaiton. Is there any issue coul
d
happen on sp_detach_db and sp_attach_db?
Thanks very much
LionelI haven't had any problems using them properly (that is, attaching databases
with sp_attach_db that were detached using sp_detach_db), but that doesn't
mean there is no possibility of issues. As with anything else, back up
first just to be on the safe side.
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"lionel" <lionel@.discussions.microsoft.com> wrote in message
news:3E57A4A7-8D73-4DD2-B6AB-562772BF86EA@.microsoft.com...
> Hello there,
> Our database data and log files were stored on UNC directory on different
> server, we are thinking to use sp_detach_db and sp_attach_db to move data
and
> log files from UNC to local disk. Becasuse we are not familiar about
> application, any minor issue could stop applicaiton. Is there any issue
could
> happen on sp_detach_db and sp_attach_db?
> Thanks very much
> Lionel
>|||Thanks for your reply, One of the further questions is that I noticed one of
our database owner is "unknow", I wonder why it would be happed.
when we use sp_attach_db to change the database owner from "unknow" to "sa",
any issue could be?
Thanks again
Lionel
"Adam Machanic" wrote:
> I haven't had any problems using them properly (that is, attaching databas
es
> with sp_attach_db that were detached using sp_detach_db), but that doesn't
> mean there is no possibility of issues. As with anything else, back up
> first just to be on the safe side.
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.datamanipulation.net
> --
>
> "lionel" <lionel@.discussions.microsoft.com> wrote in message
> news:3E57A4A7-8D73-4DD2-B6AB-562772BF86EA@.microsoft.com...
> and
> could
>
>|||You can restore user and owner settings on the target server using
sp_change_users_login and sp_changedbowner.
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"lionel" <lionel@.discussions.microsoft.com> wrote in message
news:2220E2B9-D439-407A-9DE3-3D18AF490F46@.microsoft.com...
> Thanks for your reply, One of the further questions is that I noticed one
of
> our database owner is "unknow", I wonder why it would be happed.
> when we use sp_attach_db to change the database owner from "unknow" to
"sa",[vbcol=seagreen]
> any issue could be?
> Thanks again
> Lionel
>
> "Adam Machanic" wrote:
>
databases[vbcol=seagreen]
doesn't[vbcol=seagreen]
different[vbcol=seagreen]
data[vbcol=seagreen]
issue[vbcol=seagreen]|||Hi,
Before detaching, I recommend you to do a Full database backup of your
database. So even if Attach wont work you
could use the backup to recover the database to local hard disk using
RESTORE DATABASE command.
After that as Adam suggested you could use sp_changedbowner to change the
database owner
Thanks
Hari
SQL Server MVP
"lionel" <lionel@.discussions.microsoft.com> wrote in message
news:2220E2B9-D439-407A-9DE3-3D18AF490F46@.microsoft.com...[vbcol=seagreen]
> Thanks for your reply, One of the further questions is that I noticed one
> of
> our database owner is "unknow", I wonder why it would be happed.
> when we use sp_attach_db to change the database owner from "unknow" to
> "sa",
> any issue could be?
> Thanks again
> Lionel
>
> "Adam Machanic" wrote:
>
Our database data and log files were stored on UNC directory on different
server, we are thinking to use sp_detach_db and sp_attach_db to move data an
d
log files from UNC to local disk. Becasuse we are not familiar about
application, any minor issue could stop applicaiton. Is there any issue coul
d
happen on sp_detach_db and sp_attach_db?
Thanks very much
LionelI haven't had any problems using them properly (that is, attaching databases
with sp_attach_db that were detached using sp_detach_db), but that doesn't
mean there is no possibility of issues. As with anything else, back up
first just to be on the safe side.
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"lionel" <lionel@.discussions.microsoft.com> wrote in message
news:3E57A4A7-8D73-4DD2-B6AB-562772BF86EA@.microsoft.com...
> Hello there,
> Our database data and log files were stored on UNC directory on different
> server, we are thinking to use sp_detach_db and sp_attach_db to move data
and
> log files from UNC to local disk. Becasuse we are not familiar about
> application, any minor issue could stop applicaiton. Is there any issue
could
> happen on sp_detach_db and sp_attach_db?
> Thanks very much
> Lionel
>|||Thanks for your reply, One of the further questions is that I noticed one of
our database owner is "unknow", I wonder why it would be happed.
when we use sp_attach_db to change the database owner from "unknow" to "sa",
any issue could be?
Thanks again
Lionel
"Adam Machanic" wrote:
> I haven't had any problems using them properly (that is, attaching databas
es
> with sp_attach_db that were detached using sp_detach_db), but that doesn't
> mean there is no possibility of issues. As with anything else, back up
> first just to be on the safe side.
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.datamanipulation.net
> --
>
> "lionel" <lionel@.discussions.microsoft.com> wrote in message
> news:3E57A4A7-8D73-4DD2-B6AB-562772BF86EA@.microsoft.com...
> and
> could
>
>|||You can restore user and owner settings on the target server using
sp_change_users_login and sp_changedbowner.
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"lionel" <lionel@.discussions.microsoft.com> wrote in message
news:2220E2B9-D439-407A-9DE3-3D18AF490F46@.microsoft.com...
> Thanks for your reply, One of the further questions is that I noticed one
of
> our database owner is "unknow", I wonder why it would be happed.
> when we use sp_attach_db to change the database owner from "unknow" to
"sa",[vbcol=seagreen]
> any issue could be?
> Thanks again
> Lionel
>
> "Adam Machanic" wrote:
>
databases[vbcol=seagreen]
doesn't[vbcol=seagreen]
different[vbcol=seagreen]
data[vbcol=seagreen]
issue[vbcol=seagreen]|||Hi,
Before detaching, I recommend you to do a Full database backup of your
database. So even if Attach wont work you
could use the backup to recover the database to local hard disk using
RESTORE DATABASE command.
After that as Adam suggested you could use sp_changedbowner to change the
database owner
Thanks
Hari
SQL Server MVP
"lionel" <lionel@.discussions.microsoft.com> wrote in message
news:2220E2B9-D439-407A-9DE3-3D18AF490F46@.microsoft.com...[vbcol=seagreen]
> Thanks for your reply, One of the further questions is that I noticed one
> of
> our database owner is "unknow", I wonder why it would be happed.
> when we use sp_attach_db to change the database owner from "unknow" to
> "sa",
> any issue could be?
> Thanks again
> Lionel
>
> "Adam Machanic" wrote:
>
Sunday, February 19, 2012
about processXMLdata sample,how to insert a return in end of each row data of the result text fi
I am newbie, having a job to handle some XML files into sql server 2005. In the procXMLdata sample,,pls tell me how to insert a return in end of each row data of the result text file?
I am not familiar with this sample, but my guess is that you need to use Ragged Right Flat File format and choose {CR}{LF} as the row delimiter.
Give us more of the problem's context, if this is not what you are looking for.
Thanks.
|||hi,
Thanks for your reply.
The processXMLdata sample was put in the sample directory of ms sql server,which just converted a xml file into a txt file ,using two xml task. The first was to preform XPATH method,output a variable, and the second xml task was to do XSLT method ,input the variable above, output a txt.
I know XML little , i guess the problem may be on propery of the second XML task.
Thursday, February 16, 2012
About new SQL Server 2005 Samples and Sample Databases
There are five msi files listed for downloading.
SqlServerSamples.msi
AdventureWorksDB.msi
AdventureWorksDBCI.msi
AdventureWorksBI.msi
AdventureWorksBICI.msi
What are the AdventureWorksDBCI.ms and AdventureWorksBICI.msi used for? I try to run it, but it return the message "Another version of this product is already installed" and ask me remove the old version of this product. Anybody know what I should remove?
Thanks,
Hi,
Seems that they either need to update their docuementation or change the file names, because the BI (Business Intelligence) was former written wir DW (Datawarehouse). THE CI means (like mentioned in the download page) Case sensitive means, that for example 'A' is not the same as 'a'. more samples about that can be found here:
http://www.databasejournal.com/features/mssql/article.php/3302341
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||Hi Jen,
Thanks. I are right, the CI means case insensitive.
AdventureWorksDB.msi creates a AdventureWork database with collation Latin1_General_CS_AS in your SQL Server.
AdventureWorksDBCI.msi creates a AdventureWork database with collation Latin1_General_CI_AS in your SQL Server.
Depends on the server collation setting (check the properties of server and see server collation item), you can decide which two msi files should to be downloaded and run on your machine.
Thanks,
Saturday, February 11, 2012
About DB files?
Not sure if it is appropriate to place my question in here
1.when mssql use heap file to store data and when use direct file?
2.what does index file depend on to group in mssql?
thanks in advance!
i am not sure i understand the question correctly or not.
SQL Server stored the data in table in the form of rows and columns not in files. Tables which do not have clustered index is called heap. So the answer to your first question may be, when you create a table in sql server if you add a primary key by default clustred index is created and the data stored in the table which have CI is in a sorted order.
Second question is not clear to me...
Madhu
|||DBMS need to first group on index file in order to optimize search
How does MSSQL depend on to group index?
About DB files?
Not sure if it is appropriate to place my question in here
1.when mssql use heap file to store data and when use direct file?
2.what does index file depend on to group in mssql?
thanks in advance!
i am not sure i understand the question correctly or not.
SQL Server stored the data in table in the form of rows and columns not in files. Tables which do not have clustered index is called heap. So the answer to your first question may be, when you create a table in sql server if you add a primary key by default clustred index is created and the data stored in the table which have CI is in a sorted order.
Second question is not clear to me...
Madhu
|||DBMS need to first group on index file in order to optimize search
How does MSSQL depend on to group index?
Subscribe to:
Posts (Atom)