No longer able to open up .rptproj

My visual studio .net application previously had not problem opening .rptroj
files, but now it tells me "Make sure the application for the project type
(.rptproj) is installed"
Also, when I try to create a new project, the "Business Intelligence"
project type is not listed. I have seen some suggestions on line about
removing msatinterop.dll from the PrivateAssemblies directory but this does
not change a thing for me.Try running VS from the command line with the /resetskippkgs switch. That
should do the trick. Your command would look something like:
C:\>cd C:\Program Files\Microsoft Visual Studio .NET 2003\Common7\IDE\
C:\Program Files\Microsoft Visual Studio .NET 2003\Common7\IDE>devenv
/resetskipkgs
This is assuming you have RS installed to the default directory. You would
obviously have to find where the devenv.exe file is in order to run the file.
"DBA72" wrote:
> My visual studio .net application previously had not problem opening .rptroj
> files, but now it tells me "Make sure the application for the project type
> (.rptproj) is installed"
> Also, when I try to create a new project, the "Business Intelligence"
> project type is not listed. I have seen some suggestions on line about
> removing msatinterop.dll from the PrivateAssemblies directory but this does
> not change a thing for me.|||Running devenv didn't work for me, but reinstalling MRS with the Report
Designer component checked did. Good Luck.
Bassist695 wrote:
> Try running VS from the command line with the /resetskippkgs switch.
That
> should do the trick. Your command would look something like:
> C:\>cd C:\Program Files\Microsoft Visual Studio .NET
2003\Common7\IDE\
> C:\Program Files\Microsoft Visual Studio .NET 2003\Common7\IDE>devenv
> /resetskipkgs
> This is assuming you have RS installed to the default directory. You
would
> obviously have to find where the devenv.exe file is in order to run
the file.
>
> "DBA72" wrote:
> > My visual studio .net application previously had not problem
opening .rptroj
> > files, but now it tells me "Make sure the application for the
project type
> > (.rptproj) is installed"
> >
> > Also, when I try to create a new project, the "Business
Intelligence"
> > project type is not listed. I have seen some suggestions on line
about
> > removing msatinterop.dll from the PrivateAssemblies directory but
this does
> > not change a thing for me.|||I solved this problem by reinstalling reporting services. I tried
running devenv.exe to no avail. On the default install for RS it
leaves the Report Designer unchecked. When you reinstall (or repair)
make sure this component is checked and it should solve the problem.
Bassist695 wrote:
> Try running VS from the command line with the /resetskippkgs switch.
That
> should do the trick. Your command would look something like:
> C:\>cd C:\Program Files\Microsoft Visual Studio .NET
2003\Common7\IDE\
> C:\Program Files\Microsoft Visual Studio .NET 2003\Common7\IDE>devenv
> /resetskipkgs
> This is assuming you have RS installed to the default directory. You
would
> obviously have to find where the devenv.exe file is in order to run
the file.
>
> "DBA72" wrote:
> > My visual studio .net application previously had not problem
opening .rptroj
> > files, but now it tells me "Make sure the application for the
project type
> > (.rptproj) is installed"
> >
> > Also, when I try to create a new project, the "Business
Intelligence"
> > project type is not listed. I have seen some suggestions on line
about
> > removing msatinterop.dll from the PrivateAssemblies directory but
this does
> > not change a thing for me.sql

No fields allowed in header/footer?!?

I'm an ex-Crystal Reports 8.5 user trying to cope with Visual Studio's
designer friendly interface. So please be patient & simplistic with your
responses.
If you can't place fields in page headers or footers how can you get fields
to repeat on multi-page forms, like shop travelers and packing lists, which
repeat customer and order info on every page but changes line item data?Two ways:
Rather than using a page header/footer for these section breaks, use a group
header and/or footer in a table. You can set group headers to to force a
page break or to repeat on a new page.
If you must show data in a page header or footer, add a hidden field-bound
textbox to the main report and then reference it from an item in the header
or footer (ReportItems!SalesTotal.Value). This isn't elegant but it works
for most things.
Paul Turley, MCSD, MCDBA, MSF, MCT
nospam at scout-master.com
"rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
news:FE0F30A9-057B-48FB-B8F8-E7158B312724@.microsoft.com...
> I'm an ex-Crystal Reports 8.5 user trying to cope with Visual Studio's
> designer friendly interface. So please be patient & simplistic with your
> responses.
> If you can't place fields in page headers or footers how can you get
> fields
> to repeat on multi-page forms, like shop travelers and packing lists,
> which
> repeat customer and order info on every page but changes line item data?|||You can reference the fields in the reports to do so.
HTH,, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"rs_newbie" <rsnewbie@.discussions.microsoft.com> schrieb im Newsbeitrag
news:FE0F30A9-057B-48FB-B8F8-E7158B312724@.microsoft.com...
> I'm an ex-Crystal Reports 8.5 user trying to cope with Visual Studio's
> designer friendly interface. So please be patient & simplistic with your
> responses.
> If you can't place fields in page headers or footers how can you get
> fields
> to repeat on multi-page forms, like shop travelers and packing lists,
> which
> repeat customer and order info on every page but changes line item data?|||That is right; you cannot place fields in a page header or footer. To get
round this, put a textbox in the header and use a formula that references a
textbox with the field in the body of the report. For example:
=ReportItems!OrderNumber.Value
The above expression can be placed in the page header or footer. It is
referencing a textbox called OrderNumber. If the textbox displays the field
you want, then the value is also displayed in the textbox that has the above
formula.
Charles Kangai, MCDBA, MCT
"rs_newbie" wrote:
> I'm an ex-Crystal Reports 8.5 user trying to cope with Visual Studio's
> designer friendly interface. So please be patient & simplistic with your
> responses.
> If you can't place fields in page headers or footers how can you get fields
> to repeat on multi-page forms, like shop travelers and packing lists, which
> repeat customer and order info on every page but changes line item data?|||Thanks everyone. That works great for a few fields. How about whole tables?
"Charles Kangai" wrote:
> That is right; you cannot place fields in a page header or footer. To get
> round this, put a textbox in the header and use a formula that references a
> textbox with the field in the body of the report. For example:
> =ReportItems!OrderNumber.Value
> The above expression can be placed in the page header or footer. It is
> referencing a textbox called OrderNumber. If the textbox displays the field
> you want, then the value is also displayed in the textbox that has the above
> formula.
> Charles Kangai, MCDBA, MCT
> "rs_newbie" wrote:
> > I'm an ex-Crystal Reports 8.5 user trying to cope with Visual Studio's
> > designer friendly interface. So please be patient & simplistic with your
> > responses.
> >
> > If you can't place fields in page headers or footers how can you get fields
> > to repeat on multi-page forms, like shop travelers and packing lists, which
> > repeat customer and order info on every page but changes line item data?|||Generally speaking, you don't need to do this as you can have as many tables
as you want in the body of the report. What is the specific scenario?
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
news:35AFFA86-9B8A-4547-923C-8B6F3109341D@.microsoft.com...
> Thanks everyone. That works great for a few fields. How about whole
> tables?
> "Charles Kangai" wrote:
>> That is right; you cannot place fields in a page header or footer. To get
>> round this, put a textbox in the header and use a formula that references
>> a
>> textbox with the field in the body of the report. For example:
>> =ReportItems!OrderNumber.Value
>> The above expression can be placed in the page header or footer. It is
>> referencing a textbox called OrderNumber. If the textbox displays the
>> field
>> you want, then the value is also displayed in the textbox that has the
>> above
>> formula.
>> Charles Kangai, MCDBA, MCT
>> "rs_newbie" wrote:
>> > I'm an ex-Crystal Reports 8.5 user trying to cope with Visual Studio's
>> > designer friendly interface. So please be patient & simplistic with
>> > your
>> > responses.
>> >
>> > If you can't place fields in page headers or footers how can you get
>> > fields
>> > to repeat on multi-page forms, like shop travelers and packing lists,
>> > which
>> > repeat customer and order info on every page but changes line item
>> > data?|||Why the reference doesnt function after a pagebreak?
scenario:
You put the hidden field at the top of the body.
Then you insert a header-field that refere to the hidden field.
Cause the report has a lot of data there will be 2 pages and also 2 header.
The reportItem!Name.Value on the SECOND page has no Value.
Why?
thy, Michele
"Brian Welcker [MSFT]" wrote:
> Generally speaking, you don't need to do this as you can have as many tables
> as you want in the body of the report. What is the specific scenario?
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
> news:35AFFA86-9B8A-4547-923C-8B6F3109341D@.microsoft.com...
> > Thanks everyone. That works great for a few fields. How about whole
> > tables?
> >
> > "Charles Kangai" wrote:
> >
> >> That is right; you cannot place fields in a page header or footer. To get
> >> round this, put a textbox in the header and use a formula that references
> >> a
> >> textbox with the field in the body of the report. For example:
> >>
> >> =ReportItems!OrderNumber.Value
> >>
> >> The above expression can be placed in the page header or footer. It is
> >> referencing a textbox called OrderNumber. If the textbox displays the
> >> field
> >> you want, then the value is also displayed in the textbox that has the
> >> above
> >> formula.
> >>
> >> Charles Kangai, MCDBA, MCT
> >>
> >> "rs_newbie" wrote:
> >>
> >> > I'm an ex-Crystal Reports 8.5 user trying to cope with Visual Studio's
> >> > designer friendly interface. So please be patient & simplistic with
> >> > your
> >> > responses.
> >> >
> >> > If you can't place fields in page headers or footers how can you get
> >> > fields
> >> > to repeat on multi-page forms, like shop travelers and packing lists,
> >> > which
> >> > repeat customer and order info on every page but changes line item
> >> > data?
>
>|||Because there is no instance of the textbox on the second page. The
ReportItems collection in the page header / footer refer to the items on the
page. I understand this is a limitation. Instead of using the header, could
you use an outer list that repeats on new pages?
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Michele" <Michele@.discussions.microsoft.com> wrote in message
news:EB1F86BB-A2C6-4487-9C25-DC9ADAD69EB3@.microsoft.com...
> Why the reference doesnt function after a pagebreak?
> scenario:
> You put the hidden field at the top of the body.
> Then you insert a header-field that refere to the hidden field.
> Cause the report has a lot of data there will be 2 pages and also 2
> header.
> The reportItem!Name.Value on the SECOND page has no Value.
> Why?
> thy, Michele
> "Brian Welcker [MSFT]" wrote:
>> Generally speaking, you don't need to do this as you can have as many
>> tables
>> as you want in the body of the report. What is the specific scenario?
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
>> news:35AFFA86-9B8A-4547-923C-8B6F3109341D@.microsoft.com...
>> > Thanks everyone. That works great for a few fields. How about whole
>> > tables?
>> >
>> > "Charles Kangai" wrote:
>> >
>> >> That is right; you cannot place fields in a page header or footer. To
>> >> get
>> >> round this, put a textbox in the header and use a formula that
>> >> references
>> >> a
>> >> textbox with the field in the body of the report. For example:
>> >>
>> >> =ReportItems!OrderNumber.Value
>> >>
>> >> The above expression can be placed in the page header or footer. It is
>> >> referencing a textbox called OrderNumber. If the textbox displays the
>> >> field
>> >> you want, then the value is also displayed in the textbox that has the
>> >> above
>> >> formula.
>> >>
>> >> Charles Kangai, MCDBA, MCT
>> >>
>> >> "rs_newbie" wrote:
>> >>
>> >> > I'm an ex-Crystal Reports 8.5 user trying to cope with Visual
>> >> > Studio's
>> >> > designer friendly interface. So please be patient & simplistic with
>> >> > your
>> >> > responses.
>> >> >
>> >> > If you can't place fields in page headers or footers how can you get
>> >> > fields
>> >> > to repeat on multi-page forms, like shop travelers and packing
>> >> > lists,
>> >> > which
>> >> > repeat customer and order info on every page but changes line item
>> >> > data?
>>|||The problem is that the body has 5 tables and the detail in one of the tables
can span several pages. The other tables don't repeat after page 1. This is a
problem because the information that makes the job traceable is lost . All
you get is a continuation of the detail from the current table with page
header/footer info.
"Brian Welcker [MSFT]" wrote:
> Generally speaking, you don't need to do this as you can have as many tables
> as you want in the body of the report. What is the specific scenario?
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
> news:35AFFA86-9B8A-4547-923C-8B6F3109341D@.microsoft.com...
> > Thanks everyone. That works great for a few fields. How about whole
> > tables?
> >
> > "Charles Kangai" wrote:
> >
> >> That is right; you cannot place fields in a page header or footer. To get
> >> round this, put a textbox in the header and use a formula that references
> >> a
> >> textbox with the field in the body of the report. For example:
> >>
> >> =ReportItems!OrderNumber.Value
> >>
> >> The above expression can be placed in the page header or footer. It is
> >> referencing a textbox called OrderNumber. If the textbox displays the
> >> field
> >> you want, then the value is also displayed in the textbox that has the
> >> above
> >> formula.
> >>
> >> Charles Kangai, MCDBA, MCT
> >>
> >> "rs_newbie" wrote:
> >>
> >> > I'm an ex-Crystal Reports 8.5 user trying to cope with Visual Studio's
> >> > designer friendly interface. So please be patient & simplistic with
> >> > your
> >> > responses.
> >> >
> >> > If you can't place fields in page headers or footers how can you get
> >> > fields
> >> > to repeat on multi-page forms, like shop travelers and packing lists,
> >> > which
> >> > repeat customer and order info on every page but changes line item
> >> > data?
>
>|||Can you put the tables in a list and say 'repeat on new page'? If they are
not bound to the same data source, you will need to use a subreport.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
news:96788818-6FB8-4F24-A111-D8344D11EDB2@.microsoft.com...
> The problem is that the body has 5 tables and the detail in one of the
> tables
> can span several pages. The other tables don't repeat after page 1. This
> is a
> problem because the information that makes the job traceable is lost . All
> you get is a continuation of the detail from the current table with page
> header/footer info.
> "Brian Welcker [MSFT]" wrote:
>> Generally speaking, you don't need to do this as you can have as many
>> tables
>> as you want in the body of the report. What is the specific scenario?
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
>> news:35AFFA86-9B8A-4547-923C-8B6F3109341D@.microsoft.com...
>> > Thanks everyone. That works great for a few fields. How about whole
>> > tables?
>> >
>> > "Charles Kangai" wrote:
>> >
>> >> That is right; you cannot place fields in a page header or footer. To
>> >> get
>> >> round this, put a textbox in the header and use a formula that
>> >> references
>> >> a
>> >> textbox with the field in the body of the report. For example:
>> >>
>> >> =ReportItems!OrderNumber.Value
>> >>
>> >> The above expression can be placed in the page header or footer. It is
>> >> referencing a textbox called OrderNumber. If the textbox displays the
>> >> field
>> >> you want, then the value is also displayed in the textbox that has the
>> >> above
>> >> formula.
>> >>
>> >> Charles Kangai, MCDBA, MCT
>> >>
>> >> "rs_newbie" wrote:
>> >>
>> >> > I'm an ex-Crystal Reports 8.5 user trying to cope with Visual
>> >> > Studio's
>> >> > designer friendly interface. So please be patient & simplistic with
>> >> > your
>> >> > responses.
>> >> >
>> >> > If you can't place fields in page headers or footers how can you get
>> >> > fields
>> >> > to repeat on multi-page forms, like shop travelers and packing
>> >> > lists,
>> >> > which
>> >> > repeat customer and order info on every page but changes line item
>> >> > data?
>>|||Hello-
Best I can tell this technique (ReportItems!SalesTotal.Value) only
displays data on the first page... fairly worthless for my purposes
anyway...
JCF|||It displays data on every page in which ReportItems!SalesTotal.Value exists.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"CodeFester" <fischerjc@.hotmail.com> wrote in message
news:1114809018.195146.312890@.f14g2000cwb.googlegroups.com...
> Hello-
> Best I can tell this technique (ReportItems!SalesTotal.Value) only
> displays data on the first page... fairly worthless for my purposes
> anyway...
> JCF
>|||Thanks Brian!
The list is working great in Visual Studio. The Preview ,Run and Print
Preview all show a proper rendering of the reports.
However, after deployment, the Report Manager shows several blank data
fields. The print preview is not pulling in the 0.000in margins that I've set
in my report properties. The settings are all 0.500in. If I change them to 0
the preview shows the missing data, and so does the printout. Any ideas?
Is there a way to use the same Preview/Print Preview in Report Manager that
Visual Studio uses?
"Brian Welcker [MSFT]" wrote:
> Can you put the tables in a list and say 'repeat on new page'? If they are
> not bound to the same data source, you will need to use a subreport.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
> news:96788818-6FB8-4F24-A111-D8344D11EDB2@.microsoft.com...
> > The problem is that the body has 5 tables and the detail in one of the
> > tables
> > can span several pages. The other tables don't repeat after page 1. This
> > is a
> > problem because the information that makes the job traceable is lost . All
> > you get is a continuation of the detail from the current table with page
> > header/footer info.
> >
> > "Brian Welcker [MSFT]" wrote:
> >
> >> Generally speaking, you don't need to do this as you can have as many
> >> tables
> >> as you want in the body of the report. What is the specific scenario?
> >>
> >> --
> >> Brian Welcker
> >> Group Program Manager
> >> Microsoft SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >> "rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
> >> news:35AFFA86-9B8A-4547-923C-8B6F3109341D@.microsoft.com...
> >> > Thanks everyone. That works great for a few fields. How about whole
> >> > tables?
> >> >
> >> > "Charles Kangai" wrote:
> >> >
> >> >> That is right; you cannot place fields in a page header or footer. To
> >> >> get
> >> >> round this, put a textbox in the header and use a formula that
> >> >> references
> >> >> a
> >> >> textbox with the field in the body of the report. For example:
> >> >>
> >> >> =ReportItems!OrderNumber.Value
> >> >>
> >> >> The above expression can be placed in the page header or footer. It is
> >> >> referencing a textbox called OrderNumber. If the textbox displays the
> >> >> field
> >> >> you want, then the value is also displayed in the textbox that has the
> >> >> above
> >> >> formula.
> >> >>
> >> >> Charles Kangai, MCDBA, MCT
> >> >>
> >> >> "rs_newbie" wrote:
> >> >>
> >> >> > I'm an ex-Crystal Reports 8.5 user trying to cope with Visual
> >> >> > Studio's
> >> >> > designer friendly interface. So please be patient & simplistic with
> >> >> > your
> >> >> > responses.
> >> >> >
> >> >> > If you can't place fields in page headers or footers how can you get
> >> >> > fields
> >> >> > to repeat on multi-page forms, like shop travelers and packing
> >> >> > lists,
> >> >> > which
> >> >> > repeat customer and order info on every page but changes line item
> >> >> > data?
> >>
> >>
> >>
>
>|||Do you have an example of how to get a specific table to repeat on every page
as well as individual fields (that change depending on the group) from a
table?
I'm pretty new to SRS and I need to get up to speed really fast.
Thanks in advance.
"Brian Welcker [MSFT]" wrote:
> Can you put the tables in a list and say 'repeat on new page'? If they are
> not bound to the same data source, you will need to use a subreport.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
> news:96788818-6FB8-4F24-A111-D8344D11EDB2@.microsoft.com...
> > The problem is that the body has 5 tables and the detail in one of the
> > tables
> > can span several pages. The other tables don't repeat after page 1. This
> > is a
> > problem because the information that makes the job traceable is lost . All
> > you get is a continuation of the detail from the current table with page
> > header/footer info.
> >
> > "Brian Welcker [MSFT]" wrote:
> >
> >> Generally speaking, you don't need to do this as you can have as many
> >> tables
> >> as you want in the body of the report. What is the specific scenario?
> >>
> >> --
> >> Brian Welcker
> >> Group Program Manager
> >> Microsoft SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >> "rs_newbie" <rsnewbie@.discussions.microsoft.com> wrote in message
> >> news:35AFFA86-9B8A-4547-923C-8B6F3109341D@.microsoft.com...
> >> > Thanks everyone. That works great for a few fields. How about whole
> >> > tables?
> >> >
> >> > "Charles Kangai" wrote:
> >> >
> >> >> That is right; you cannot place fields in a page header or footer. To
> >> >> get
> >> >> round this, put a textbox in the header and use a formula that
> >> >> references
> >> >> a
> >> >> textbox with the field in the body of the report. For example:
> >> >>
> >> >> =ReportItems!OrderNumber.Value
> >> >>
> >> >> The above expression can be placed in the page header or footer. It is
> >> >> referencing a textbox called OrderNumber. If the textbox displays the
> >> >> field
> >> >> you want, then the value is also displayed in the textbox that has the
> >> >> above
> >> >> formula.
> >> >>
> >> >> Charles Kangai, MCDBA, MCT
> >> >>
> >> >> "rs_newbie" wrote:
> >> >>
> >> >> > I'm an ex-Crystal Reports 8.5 user trying to cope with Visual
> >> >> > Studio's
> >> >> > designer friendly interface. So please be patient & simplistic with
> >> >> > your
> >> >> > responses.
> >> >> >
> >> >> > If you can't place fields in page headers or footers how can you get
> >> >> > fields
> >> >> > to repeat on multi-page forms, like shop travelers and packing
> >> >> > lists,
> >> >> > which
> >> >> > repeat customer and order info on every page but changes line item
> >> >> > data?
> >>
> >>
> >>
>
>

No connection

Hello,

New development machine with Sql Server Express and Visual Web Developer.

I created a database then tried to connect from a test page on localhost and it worked. Then I tried from the internet domain and could not. So under the

Surface Area Configuration, I change the Remote Connections to Using both TCP/IP and named pipes and restarted the Database Engine. But

I still could not connect. So I restarted the machine. Now I can't view the page on localhost either. I can view a different web page so the Web server is

working.

I get the following as the exception:Error reading the database: Cannot open user default database. Login failed.Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

My connection string is: "Data Source=.\SQLEXPRESS;Integrated Security=True;AttachDBFilename=|DataDirectory|Externalresearch.mdf;User Instance=True"

Any suggestions?

Okay I found out why. If I have Web Developer open (with the database connection open) I cannot connect from the browser. But

if I close Web Developer then I can connect from the browser (ie, view my test page).

Is this because it's the same machine that I am both viewing the web page and hosting Sql server (ie, the user can only be used once)?

|||

Hi,

It's a little strange that it says you're using the Network Service to connect to SQL Server.

Are you connecting to the SQL Server through Internet with the windows authentication? If so, that's not supported, since the windows identity cannot be passed through internet.

|||

Kevin,

Everything including the database is on one machine. I'm using Windows authentication. So when I'm in Visual developer and connect

to the database, my web page (again hosted on the same machine) cannot connect to the database. It's a new installation of everything

with defaults setup. How can I work on the database while my web pages can still access the database? I just downloaded Managament

Studio Express, will this do?

Thanks for any help

|||

Hi,

Yes, you can use Management Studio to grant database access permission to the Network Service account.

By default, it does not have permission to the SQL Server. After granting the access, it will be working fine, I think.

sql

No "(local)" server name in servers list for SQL Server 2005

I have a new install of SQL SERVER 2005 on a new machine.
When I am using Visual Studio 2005 Server Explorer "Add connection" dialog
or MS Access ADE Connection "Data Link Properties", there is no (local)
entry in drop-down "server Name" list. However the actual server name is
listed and I can use it for successful connection.
My main problem is that I am trying to get from SourceSafe a big Access ADE
project and it complains that it is not able to connect to (local) server for
almost each form/report.
Is the "(local)" server removed in SQL SERVER 2005 by design or it is a
problem with my installation?
If it is a setup problem, how can I add (local) to the list of available
servers?
By the way,when I manually typed "(local)" server name, VS 2005 "add
connection" accepted it , but ADE Connection "Data Link Properties" reported
"Sql Server doesn't exist or access is denied"
Michael Freidgeim.
<a href="http://links.10026.com/?link=http://geekswithblogs.net/mnf/">
My Blog: http://geekswithblogs.net/mnf/
</a>
I was able to fix the problem. ADE Connection "Data Link Properties" accepts
manually typed "(local)" after I changed the following:
1. In SQL Server 2005 Configuration Manager selected "SQL server 2005
Network Configuration/Protocols for MSSQLSERVER" and enabled "Tcp/IP".
Note that "SQL Native Client Configuration/Client Configuration" had already
"Tcp/IP" enabled.
2. Restarted SQL Server service.
Michael Freidgeim.
<a href="http://links.10026.com/?link=http://geekswithblogs.net/mnf/">
My Blog: http://geekswithblogs.net/mnf/
</a>
"Michael Freidgeim" wrote:

> I have a new install of SQL SERVER 2005 on a new machine.
> When I am using Visual Studio 2005 Server Explorer "Add connection" dialog
> or MS Access ADE Connection "Data Link Properties", there is no (local)
> entry in drop-down "server Name" list. However the actual server name is
> listed and I can use it for successful connection.
> My main problem is that I am trying to get from SourceSafe a big Access ADE
> project and it complains that it is not able to connect to (local) server for
> almost each form/report.
> Is the "(local)" server removed in SQL SERVER 2005 by design or it is a
> problem with my installation?
> If it is a setup problem, how can I add (local) to the list of available
> servers?
> By the way,when I manually typed "(local)" server name, VS 2005 "add
> connection" accepted it , but ADE Connection "Data Link Properties" reported
> "Sql Server doesn't exist or access is denied"
> Michael Freidgeim.
> <a href="http://links.10026.com/?link=http://geekswithblogs.net/mnf/">
> My Blog: http://geekswithblogs.net/mnf/
> </a>

No "(local)" server name in servers list for SQL Server 2005

I have a new install of SQL SERVER 2005 on a new machine.
When I am using Visual Studio 2005 Server Explorer "Add connection" dialog
or MS Access ADE Connection "Data Link Properties", there is no (local)
entry in drop-down "server Name" list. However the actual server name is
listed and I can use it for successful connection.
My main problem is that I am trying to get from SourceSafe a big Access ADE
project and it complains that it is not able to connect to (local) server fo
r
almost each form/report.
Is the "(local)" server removed in SQL SERVER 2005 by design or it is a
problem with my installation?
If it is a setup problem, how can I add (local) to the list of available
servers?
By the way,when I manually typed "(local)" server name, VS 2005 "add
connection" accepted it , but ADE Connection "Data Link Properties" reporte
d
"Sql Server doesn't exist or access is denied"
Michael Freidgeim.
<a href="http://links.10026.com/?link=http://geekswithblogs.net/mnf/">
My Blog: http://geekswithblogs.net/mnf/
</a>I was able to fix the problem. ADE Connection "Data Link Properties" accept
s
manually typed "(local)" after I changed the following:
1. In SQL Server 2005 Configuration Manager selected "SQL server 2005
Network Configuration/Protocols for MSSQLSERVER" and enabled "Tcp/IP".
Note that "SQL Native Client Configuration/Client Configuration" had already
"Tcp/IP" enabled.
2. Restarted SQL Server service.
Michael Freidgeim.
<a href="http://links.10026.com/?link=http://geekswithblogs.net/mnf/">
My Blog: http://geekswithblogs.net/mnf/
</a>
"Michael Freidgeim" wrote:

> I have a new install of SQL SERVER 2005 on a new machine.
> When I am using Visual Studio 2005 Server Explorer "Add connection" dialog
> or MS Access ADE Connection "Data Link Properties", there is no (local)
> entry in drop-down "server Name" list. However the actual server name is
> listed and I can use it for successful connection.
> My main problem is that I am trying to get from SourceSafe a big Access AD
E
> project and it complains that it is not able to connect to (local) server
for
> almost each form/report.
> Is the "(local)" server removed in SQL SERVER 2005 by design or it is a
> problem with my installation?
> If it is a setup problem, how can I add (local) to the list of available
> servers?
> By the way,when I manually typed "(local)" server name, VS 2005 "add
> connection" accepted it , but ADE Connection "Data Link Properties" repor
ted
> "Sql Server doesn't exist or access is denied"
> Michael Freidgeim.
> <a href="http://links.10026.com/?link=http://geekswithblogs.net/mnf/">
> My Blog: http://geekswithblogs.net/mnf/
> </a>