Integrate SQL Server Management Studio with Sharepoint

Our IT production support team stores miscellaneous SQL scripts for support
items on a SharePoint server (WSS 3). However, to edit these scripts, the
user must save a local copy of the file, make the change and then re-upload
it, ensuring the name is the same. This triggers SharePoint to create a new
version of that script.
Is there an easier way to integrate the SQL 2005 Management Studio with
Sharepoint - maybe make it more like you are using SourceSafe, where you
have a project file with scripts in it and you can right click to Check Out,
Check In, etc?
Hi,
I noticed that you also have a post regarding this issue in
microsoft.public.sharepoint.windowsservices and our professional there will
assist you under that post. For further communications, please directly
reply to him.
Thanks for using Microsoft Managed Newsgroup. Have a nice day!
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====

Integraged to Sharepoint mode, credential problems

I think I have Sharepoint and Reporting services correctly installed to use
windows trusted accounts, (using domain Active Directory logins, but not
Kerberos).
While writing my report, I designed the data set to use windows
authentication (instead of a SQL Server authentication).
From the Report Designer,(report runs fine) the deploy repeatedly asks for
Reporting Services login and won't accept any account credentials at all.
I can upload the report using Sharepoint but when I run the report I get
this error message: "An error has occurred during report processing. This
data source is configured to use Windows integrated securi6ty. Windows
integrated security is either disabled for this report server or your report
server is using Trusted account mode."
Thanks for any assistance,
ShirleyIf using the MOSS 2007 (Microsoft Office Sharepoint Server) , check that the
settings in the Reporting Services Managemnet section for security is set to
Windows Integrated and not Trusted.
"ShirleyH" wrote:
> I think I have Sharepoint and Reporting services correctly installed to use
> windows trusted accounts, (using domain Active Directory logins, but not
> Kerberos).
> While writing my report, I designed the data set to use windows
> authentication (instead of a SQL Server authentication).
> From the Report Designer,(report runs fine) the deploy repeatedly asks for
> Reporting Services login and won't accept any account credentials at all.
> I can upload the report using Sharepoint but when I run the report I get
> this error message: "An error has occurred during report processing. This
> data source is configured to use Windows integrated securi6ty. Windows
> integrated security is either disabled for this report server or your report
> server is using Trusted account mode."
> Thanks for any assistance,
> Shirley
>

Installing SQL 2005 onto a drive other than C:

Our systems have a server set up that we're planning to put Sharepoint
and SQL 2005 on.
We've run into a problem installing SQL - trying to force it to the D
drive (where we've got plenty of space), will not complete. It gives an
error about the time it gets to the Reporting Services notice (it does
this whether Reporting services is going to be installed or not) and
just quits.
The C drive has just a limited amount of space on it.
How can you force SQL 2005 to install entirely on a second drive?
BCDuring the install you will have a screen that allows you to choose what
you want to install. There is an Advanced button - click it and you
can change the drive there. I just did that for the same reason.
Blasting Cap wrote:
> Our systems have a server set up that we're planning to put Sharepoint
> and SQL 2005 on.
> We've run into a problem installing SQL - trying to force it to the D
> drive (where we've got plenty of space), will not complete. It gives an
> error about the time it gets to the Reporting Services notice (it does
> this whether Reporting services is going to be installed or not) and
> just quits.
> The C drive has just a limited amount of space on it.
> How can you force SQL 2005 to install entirely on a second drive?
> BC
--
Brett I. Holcomb
brettholcomb@.R777bellsouth.net
Remove R777 to email|||I thought we had tried that, but it gets to a certain point where it
just gives an error message & quits, even though I recall looking at the
info flying by and seeing D:\.... next to it.
BC
Brett I. Holcomb wrote:
> During the install you will have a screen that allows you to choose what
> you want to install. There is an Advanced button - click it and you
> can change the drive there. I just did that for the same reason.
> Blasting Cap wrote:
>> Our systems have a server set up that we're planning to put Sharepoint
>> and SQL 2005 on.
>> We've run into a problem installing SQL - trying to force it to the D
>> drive (where we've got plenty of space), will not complete. It gives
>> an error about the time it gets to the Reporting Services notice (it
>> does this whether Reporting services is going to be installed or not)
>> and just quits.
>> The C drive has just a limited amount of space on it.
>> How can you force SQL 2005 to install entirely on a second drive?
>> BC
>|||Do you have enough space on D? It's on one of the earlier screens and
you have go go to the advanced and change it for all the items you are
installing.
Blasting Cap wrote:
> I thought we had tried that, but it gets to a certain point where it
> just gives an error message & quits, even though I recall looking at the
> info flying by and seeing D:\.... next to it.
> BC
>
> Brett I. Holcomb wrote:
>> During the install you will have a screen that allows you to choose
>> what you want to install. There is an Advanced button - click it and
>> you can change the drive there. I just did that for the same reason.
>> Blasting Cap wrote:
>> Our systems have a server set up that we're planning to put
>> Sharepoint and SQL 2005 on.
>> We've run into a problem installing SQL - trying to force it to the D
>> drive (where we've got plenty of space), will not complete. It gives
>> an error about the time it gets to the Reporting Services notice (it
>> does this whether Reporting services is going to be installed or not)
>> and just quits.
>> The C drive has just a limited amount of space on it.
>> How can you force SQL 2005 to install entirely on a second drive?
>> BC
--
Brett I. Holcomb
brettholcomb@.R777bellsouth.net
Remove R777 to email|||The D drive has around 30 gigs on it or more, the C drive has about 6-10
gigs on it, about half of which is used by the OS.
If its on one of the earlier screens, I know we changed it there, and it
gets to Reporting Services, and gives an error, and won't continue.
BC
Brett I. Holcomb wrote:
> Do you have enough space on D? It's on one of the earlier screens and
> you have go go to the advanced and change it for all the items you are
> installing.
>
> Blasting Cap wrote:
>> I thought we had tried that, but it gets to a certain point where it
>> just gives an error message & quits, even though I recall looking at
>> the info flying by and seeing D:\.... next to it.
>> BC
>>
>> Brett I. Holcomb wrote:
>> During the install you will have a screen that allows you to choose
>> what you want to install. There is an Advanced button - click it
>> and you can change the drive there. I just did that for the same
>> reason.
>> Blasting Cap wrote:
>> Our systems have a server set up that we're planning to put
>> Sharepoint and SQL 2005 on.
>> We've run into a problem installing SQL - trying to force it to the
>> D drive (where we've got plenty of space), will not complete. It
>> gives an error about the time it gets to the Reporting Services
>> notice (it does this whether Reporting services is going to be
>> installed or not) and just quits.
>> The C drive has just a limited amount of space on it.
>> How can you force SQL 2005 to install entirely on a second drive?
>> BC
>|||BC,
Could you be more precise on the amount of "FREE" space on your drives?
You say your C drive has about 6-10 gigs on it and then goes on and say half
of which is used by the OS. Does this mean it has 3 gigs of FREE space? If
so, it has enough free space to install SQL 2005.
"Blasting Cap" wrote:
> The D drive has around 30 gigs on it or more, the C drive has about 6-10
> gigs on it, about half of which is used by the OS.
> If its on one of the earlier screens, I know we changed it there, and it
> gets to Reporting Services, and gives an error, and won't continue.
> BC
> Brett I. Holcomb wrote:
> > Do you have enough space on D? It's on one of the earlier screens and
> > you have go go to the advanced and change it for all the items you are
> > installing.
> >
> >
> > Blasting Cap wrote:
> >> I thought we had tried that, but it gets to a certain point where it
> >> just gives an error message & quits, even though I recall looking at
> >> the info flying by and seeing D:\.... next to it.
> >>
> >> BC
> >>
> >>
> >> Brett I. Holcomb wrote:
> >> During the install you will have a screen that allows you to choose
> >> what you want to install. There is an Advanced button - click it
> >> and you can change the drive there. I just did that for the same
> >> reason.
> >>
> >> Blasting Cap wrote:
> >> Our systems have a server set up that we're planning to put
> >> Sharepoint and SQL 2005 on.
> >>
> >> We've run into a problem installing SQL - trying to force it to the
> >> D drive (where we've got plenty of space), will not complete. It
> >> gives an error about the time it gets to the Reporting Services
> >> notice (it does this whether Reporting services is going to be
> >> installed or not) and just quits.
> >>
> >> The C drive has just a limited amount of space on it.
> >>
> >> How can you force SQL 2005 to install entirely on a second drive?
> >>
> >> BC
> >>
> >
>|||Jeff -
The amount of free space on the C drive is around 3-4 gigs (I think it
is only a 6 GB partition). The D drive is around a 30 gig partition,
which has between 25-28GB free.
The problem is that we are trying to put both SQL 2005 AND Sharepoint
2007 on the same server, and we cannot make SQL 2005 install completely
to the D drive - the install quits with an error message (500000 I
believe). The problem with having SQL 2005 on the C drive is that we
cannot make Sharepoint 2007 go to the D drive either - it insists on
installing on C too - and there's not enough space on C for both.
BC
Jeff Tu wrote:
> BC,
> Could you be more precise on the amount of "FREE" space on your drives?
> You say your C drive has about 6-10 gigs on it and then goes on and say half
> of which is used by the OS. Does this mean it has 3 gigs of FREE space? If
> so, it has enough free space to install SQL 2005.
> "Blasting Cap" wrote:
>> The D drive has around 30 gigs on it or more, the C drive has about 6-10
>> gigs on it, about half of which is used by the OS.
>> If its on one of the earlier screens, I know we changed it there, and it
>> gets to Reporting Services, and gives an error, and won't continue.
>> BC
>> Brett I. Holcomb wrote:
>> Do you have enough space on D? It's on one of the earlier screens and
>> you have go go to the advanced and change it for all the items you are
>> installing.
>>
>> Blasting Cap wrote:
>> I thought we had tried that, but it gets to a certain point where it
>> just gives an error message & quits, even though I recall looking at
>> the info flying by and seeing D:\.... next to it.
>> BC
>>
>> Brett I. Holcomb wrote:
>> During the install you will have a screen that allows you to choose
>> what you want to install. There is an Advanced button - click it
>> and you can change the drive there. I just did that for the same
>> reason.
>> Blasting Cap wrote:
>> Our systems have a server set up that we're planning to put
>> Sharepoint and SQL 2005 on.
>> We've run into a problem installing SQL - trying to force it to the
>> D drive (where we've got plenty of space), will not complete. It
>> gives an error about the time it gets to the Reporting Services
>> notice (it does this whether Reporting services is going to be
>> installed or not) and just quits.
>> The C drive has just a limited amount of space on it.
>> How can you force SQL 2005 to install entirely on a second drive?
>> BC

Installing SQL 2000 on Win2003 server, with Sharepoint 2003

OK so everytime I try to install SQL server onto my server that is Windows
2003 with Sharepoint 2003 it fails. Is there something that I need to know
or some process that I'm missing? Thanks!
Can you tell us a bit more. What error do you get. Also, take a look at
%windir%\sqlstp.log file to see what causes the failure.
"Lee" <leemack33@.hotmail.com> wrote in message
news:7494CF87-707B-42DA-B1B2-98D446FEA2EA@.microsoft.com...
> OK so everytime I try to install SQL server onto my server that is Windows
> 2003 with Sharepoint 2003 it fails. Is there something that I need to know
> or some process that I'm missing? Thanks!
|||Having Sharepoint should not interfere with anything related to the sql
install.. As OJ says, in the windows directory there should be a file called
Sqlstp.log. Take a look at the log, it shows everthing that is going on
regarding the install.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Lee" <leemack33@.hotmail.com> wrote in message
news:7494CF87-707B-42DA-B1B2-98D446FEA2EA@.microsoft.com...
> OK so everytime I try to install SQL server onto my server that is Windows
> 2003 with Sharepoint 2003 it fails. Is there something that I need to
know
> or some process that I'm missing? Thanks!
|||Except that Sharepoint Sever installs MSDE unless you tell it otherwise. I
suspect that your SQL Server install is conflicting with the existing MSDE
copy. Normally, Sharepoint will install a named instance called
SHAREPOINTPORTAL that should not interefere with a default instance or some
other named instance you choose that is different than from above; however,
you will need to choose a listening port or allow it to be dynamic.
Do as the others suggest and check th setup log.
Sincerely,
Anthony Thomas

"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:u5sPQLp5EHA.1400@.TK2MSFTNGP11.phx.gbl...
Having Sharepoint should not interfere with anything related to the sql
install.. As OJ says, in the windows directory there should be a file called
Sqlstp.log. Take a look at the log, it shows everthing that is going on
regarding the install.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Lee" <leemack33@.hotmail.com> wrote in message
news:7494CF87-707B-42DA-B1B2-98D446FEA2EA@.microsoft.com...
> OK so everytime I try to install SQL server onto my server that is Windows
> 2003 with Sharepoint 2003 it fails. Is there something that I need to
know
> or some process that I'm missing? Thanks!
|||Hi Lee,
As oj and MVP Wayne suggested, you are welcome to post
c:\windows\sqlstp.log here and we will help troubleshooting this for you.
Also, anything available in Event Log might help. More detailed
descriptions, I believe, will make us closer to the resolution.
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Installing SQL 2000 on Win2003 server, with Sharepoint 2003

OK so everytime I try to install SQL server onto my server that is Windows
2003 with Sharepoint 2003 it fails. Is there something that I need to know
or some process that I'm missing? Thanks!Can you tell us a bit more. What error do you get. Also, take a look at
%windir%\sqlstp.log file to see what causes the failure.
"Lee" <leemack33@.hotmail.com> wrote in message
news:7494CF87-707B-42DA-B1B2-98D446FEA2EA@.microsoft.com...
> OK so everytime I try to install SQL server onto my server that is Windows
> 2003 with Sharepoint 2003 it fails. Is there something that I need to know
> or some process that I'm missing? Thanks!|||Having Sharepoint should not interfere with anything related to the sql
install.. As OJ says, in the windows directory there should be a file called
Sqlstp.log. Take a look at the log, it shows everthing that is going on
regarding the install.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Lee" <leemack33@.hotmail.com> wrote in message
news:7494CF87-707B-42DA-B1B2-98D446FEA2EA@.microsoft.com...
> OK so everytime I try to install SQL server onto my server that is Windows
> 2003 with Sharepoint 2003 it fails. Is there something that I need to
know
> or some process that I'm missing? Thanks!|||Except that Sharepoint Sever installs MSDE unless you tell it otherwise. I
suspect that your SQL Server install is conflicting with the existing MSDE
copy. Normally, Sharepoint will install a named instance called
SHAREPOINTPORTAL that should not interefere with a default instance or some
other named instance you choose that is different than from above; however,
you will need to choose a listening port or allow it to be dynamic.
Do as the others suggest and check th setup log.
Sincerely,
Anthony Thomas
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:u5sPQLp5EHA.1400@.TK2MSFTNGP11.phx.gbl...
Having Sharepoint should not interfere with anything related to the sql
install.. As OJ says, in the windows directory there should be a file called
Sqlstp.log. Take a look at the log, it shows everthing that is going on
regarding the install.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Lee" <leemack33@.hotmail.com> wrote in message
news:7494CF87-707B-42DA-B1B2-98D446FEA2EA@.microsoft.com...
> OK so everytime I try to install SQL server onto my server that is Windows
> 2003 with Sharepoint 2003 it fails. Is there something that I need to
know
> or some process that I'm missing? Thanks!|||Hi Lee,
As oj and MVP Wayne suggested, you are welcome to post
c:\windows\sqlstp.log here and we will help troubleshooting this for you.
Also, anything available in Event Log might help. More detailed
descriptions, I believe, will make us closer to the resolution.
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!