Deploying with sql server express

I have developed a windows mobile 5.0 application that is currently syncing with sql server 2005. I want to deploy the application with sql server express for the client. What do I need to do to make this work?

Thank you.

It depends on how you're syncing. If you're using manual implementation via SQL Client on device, that would work with properly configured SQL 2005 Express as well.

If you using SQL Mobile RDA or replication, you would have to implement manual sync using SQL Client as Express offers no RDA/Replication support.

|||I am using replication. Can you direct me to some reference material that can assist me in changing to manual sync?|||Also, to test with sql server express will I need to install it on my computer? I am running sql 2005 and visual studio 2005. Can I load express in addition to what I have installed. I do not want to un-install anything that I have currently. What is your suggestion?|||

I'm not aware of any reference materials on that. The idea is very simple - you go through all records in one db and compare them with records in another db. If they are different, you'd need to synchronize them as appropriate in your particular case. For example:

Before:

SQL Mobile SQL Express Action

1-foo 1-foo Same data, do nothing

2-bar 2-foobar Data changed, copy from Express to Mobile

2-some <nothing> Record deleted, delete from Mobile

(or is it added on device? - that's for you to track)

Before:

SQL Mobile SQL Express

1-foo 1-foo

2-foobar 2-foobar

As far as I know you can run SQL Express and SQL Server side by side, though you would need to use nonstandard port.

|||

some honest, non-politically correct advice - I wouldn't install SQL Server 2005 and SQL Express on the same machine. it can cause you a lot of difficult issues - I'm not saying it can't be made to work, but you're asking for a day of searching newsgroups to resolve the issues that this introduces. either remove SQL Server and re-run the VS2005 setup, choosing SQL Express as an optional install component, or use a separate box to run SQL Express on.

-Darren

Deploying SQL Server 2005 Express

Hello

1.) Is there any solution for integrating the deployment of the sql server express into the setup project of my vb 2005 app ? 'Cause it is too much to install the framework... then the sql server and then the app....... Any help would be appreciated!

Thx

This may help:

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

Buck Woody

Deploying SQL Server 2005 Express

Hello

1.) Is there any solution for integrating the deployment of the sql server express into the setup project of my vb 2005 app ? 'Cause it is too much to install the framework... then the sql server and then the app....... Any help would be appreciated!

Thx

This may help:

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

Buck Woody

Deploying SQL Express with ASP.Net Application

I have a small ASP.Net application developed in VS 2005 that I would like to deploy with SQL Express.

I have included the MDF file in the Application and added SQL Express as a pre-requisite for the Setup and Deployment project.

It installs SQL Express but when it tries to connect I receive:
"This is not a valid login Cannot open user default database. Login failed. Login failed for user 'NT AUTHORITY\SYSTEM'."

I don't seem to have any options using the "prerequisite options in VS 2005 in terms of command line deployment parameters.

Likewise I would prefer to attach the database to the instance (because I need to write a connection string from a PDA using RDA and I have zero clue how to do RDA directly back to the file).

Thanks for any help!
If you do not impersinate the user within your Asp application, the service account which the ASP Service is running with is used to connect to the SQL Server. If this account is not priviledged to access the server, you will get the mentioned error message. I don′t know how your application design is, but if you want to leave it as it is, you will have to grant access for the SYSTEM account to the server.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

Deploying SQL Express Throughout the Organization/Enterprise

What are some recommended methods for deploying SQL Express throughout an entire organization? It appears that Active Directory/GPO deployment is out of the equation.

Thanks,

Shane

hi Shane,

as SQLExpress is SQL Server, and as SQL Server is a service potentially serving lot's of user, SQLExpress is usually installed on a machine available through the whole lan.. all the clients connect to that instance and it answers to all the incoming requests... this is the "traditional" scenario of an enterprise wide database server...

what is your "problem"?

regards

|||

In our case SQL Express needs to be deployed to each PC because the product is used connected and disconnected to the network. Is there a documented or recommended method of deploying SQL Express to each PC?

Thanks,

Shane

|||

hi Shane,

a nice article has been written by Robert Walters including ClickOnce as well..

regards

|||

Andrea,

Thanks for the information. I have seen that article before and it is very good. We are using the ClickOnce bootstrapper but not actually using ClickOnce itself. What I am really looking for is recommendations on pushing SQL Express to PCs in an organization. Active Directory/GPO is commonly used for Windows Installer installations and while SQL Express is a Windows Installer installation under the hood it doesn't appear it would be practical and possibly not even possible to push it out this way. Is this a valid assessment? There are other electronic software delivery tools out there like SMS that may do the job, but we don't have experience with those tools. Would these tools be appropraite for pushing out SQL Express? Has anyone tried this successfully?

Thanks,

Shane

Deploying SQL Express 2005

Hello,
I work for a company that manages computers and their software using Active Directory. One of our packages requires SQL Express 2005, and so far I've been unable to find a good resource online. All I need to do is find a .msi file or a batch script that will install it. Thanks!

Start here http://msdn.microsoft.com/vstudio/express/

Deploying Report asks for Reporting Services Login, but won't take

Recently setup my first Sharepoint (wss 3.0, sp2) site including integrated
Report Services. I have SQL Server 2005 (full version, not the express
version) installed on the same computer. I think I did a farm install, but
installed everything on one computer. I do plan on using some linked servers
to this 2005 box to pull in data from elsewhere. My report views perfectly
in SQLServer Business Intelligence Dev.
I must have accounts set up wrong somewhere, because when I go to deploy a
report it keeps popping up a Reporting Services Login Dialog box. No matter
what account I put in, or in what format (with or without the domain portion
of the account) it just blinks and comes back to the reporting services login
dialog box.
When I try uploading from Sharepoint into the doc lib,
I have searched through other similar sounding posts, and through the
documentation and I can't figure this one out.
Here is some pertinent info:
In Reporting Services Configuration Manager:
Windows Service Identity: The service Account is set to a domain acct
(domainname\SQLSrvcA), and Windows acct is selected, with the same acct name
specified.
Web Service identity: ASP.Net Service Acct = (tried both NT
Authority\Network Service and with domainname\SQLSrvcA)
Database Setup: Credential type is Windows Credentials, with the account
name: domainname\SQLSrvcA
The link on the Sharepoint Integration page works.
I do not have Kerberos setup. Using NTLM.
Anonymous Access is turned off.
Domainname\SQLSrvcA has been added to the local admin group.
Domainname\SQLSrvcA has been added as a top level Sharepoint Site Collection
Administrator, and Full Control, Design, Contribute, Read rights.
In SQL Server, domainname\SQLSrvcA is dbo for the reportserver db, the
reportservertemp db, on the reportservertemp db this acct also has RSExecRole
rights. This account is also dbo for the SharePoint_AdminContent db, public
and WSS_Content_Application_Pools rights to the Sharepoint_Config db, dbo for
the SharepointContent db.
The SQL Server properties are set for both SQL and Windows authentication.
SQL2005 Surface Area Feature Config shows Windows Integrated Security
enabled. (have also tested with it disabled and had the same results).
I did use the "default website", but changed the port to 8080. Going to
http:/servername:8080/reportserver works.
In IIS, looking at the properties for the default website, Anonymous access
is not enabled, and integrated windows authentication is on.
I am working on building this Shareoint site out as a portal. Folks will
only be able to get to it from within our domain. I want them to be able to
go straight to sharepoint without logging in (which was working before I
installed Reporting services). I then want them to be able to pick reports
and run them without any further authentication requests.
Thank you all for any assistance you can provide.
ShirleyWith integrated security it is looking for you (when deploying). Is your
account setup in the local administrators group on the server?
Also, I recommend against using linked servers. There is no need to do this.
Instead you have the data source setup to the server you want to pull the
data from.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
news:893DF211-DEE7-4E99-9FB4-FDA8C47585FD@.microsoft.com...
> Recently setup my first Sharepoint (wss 3.0, sp2) site including
> integrated
> Report Services. I have SQL Server 2005 (full version, not the express
> version) installed on the same computer. I think I did a farm install,
> but
> installed everything on one computer. I do plan on using some linked
> servers
> to this 2005 box to pull in data from elsewhere. My report views
> perfectly
> in SQLServer Business Intelligence Dev.
> I must have accounts set up wrong somewhere, because when I go to deploy a
> report it keeps popping up a Reporting Services Login Dialog box. No
> matter
> what account I put in, or in what format (with or without the domain
> portion
> of the account) it just blinks and comes back to the reporting services
> login
> dialog box.
> When I try uploading from Sharepoint into the doc lib,
> I have searched through other similar sounding posts, and through the
> documentation and I can't figure this one out.
> Here is some pertinent info:
> In Reporting Services Configuration Manager:
> Windows Service Identity: The service Account is set to a domain acct
> (domainname\SQLSrvcA), and Windows acct is selected, with the same acct
> name
> specified.
> Web Service identity: ASP.Net Service Acct = (tried both NT
> Authority\Network Service and with domainname\SQLSrvcA)
> Database Setup: Credential type is Windows Credentials, with the account
> name: domainname\SQLSrvcA
>
> The link on the Sharepoint Integration page works.
> I do not have Kerberos setup. Using NTLM.
> Anonymous Access is turned off.
> Domainname\SQLSrvcA has been added to the local admin group.
> Domainname\SQLSrvcA has been added as a top level Sharepoint Site
> Collection
> Administrator, and Full Control, Design, Contribute, Read rights.
> In SQL Server, domainname\SQLSrvcA is dbo for the reportserver db, the
> reportservertemp db, on the reportservertemp db this acct also has
> RSExecRole
> rights. This account is also dbo for the SharePoint_AdminContent db,
> public
> and WSS_Content_Application_Pools rights to the Sharepoint_Config db, dbo
> for
> the SharepointContent db.
> The SQL Server properties are set for both SQL and Windows authentication.
> SQL2005 Surface Area Feature Config shows Windows Integrated Security
> enabled. (have also tested with it disabled and had the same results).
>
> I did use the "default website", but changed the port to 8080. Going to
> http:/servername:8080/reportserver works.
> In IIS, looking at the properties for the default website, Anonymous
> access
> is not enabled, and integrated windows authentication is on.
>
> I am working on building this Shareoint site out as a portal. Folks will
> only be able to get to it from within our domain. I want them to be able
> to
> go straight to sharepoint without logging in (which was working before I
> installed Reporting services). I then want them to be able to pick reports
> and run them without any further authentication requests.
> Thank you all for any assistance you can provide.
> Shirley
>|||I have put in my own account (which is a domain admin acct, and a local admin
acct) but it still doesn't take it, it just blinks and gives me the dialog
box back.
"Bruce L-C [MVP]" wrote:
> With integrated security it is looking for you (when deploying). Is your
> account setup in the local administrators group on the server?
> Also, I recommend against using linked servers. There is no need to do this.
> Instead you have the data source setup to the server you want to pull the
> data from.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
> news:893DF211-DEE7-4E99-9FB4-FDA8C47585FD@.microsoft.com...
> > Recently setup my first Sharepoint (wss 3.0, sp2) site including
> > integrated
> > Report Services. I have SQL Server 2005 (full version, not the express
> > version) installed on the same computer. I think I did a farm install,
> > but
> > installed everything on one computer. I do plan on using some linked
> > servers
> > to this 2005 box to pull in data from elsewhere. My report views
> > perfectly
> > in SQLServer Business Intelligence Dev.
> >
> > I must have accounts set up wrong somewhere, because when I go to deploy a
> > report it keeps popping up a Reporting Services Login Dialog box. No
> > matter
> > what account I put in, or in what format (with or without the domain
> > portion
> > of the account) it just blinks and comes back to the reporting services
> > login
> > dialog box.
> >
> > When I try uploading from Sharepoint into the doc lib,
> > I have searched through other similar sounding posts, and through the
> > documentation and I can't figure this one out.
> >
> > Here is some pertinent info:
> > In Reporting Services Configuration Manager:
> > Windows Service Identity: The service Account is set to a domain acct
> > (domainname\SQLSrvcA), and Windows acct is selected, with the same acct
> > name
> > specified.
> > Web Service identity: ASP.Net Service Acct = (tried both NT
> > Authority\Network Service and with domainname\SQLSrvcA)
> > Database Setup: Credential type is Windows Credentials, with the account
> > name: domainname\SQLSrvcA
> >
> >
> > The link on the Sharepoint Integration page works.
> > I do not have Kerberos setup. Using NTLM.
> > Anonymous Access is turned off.
> > Domainname\SQLSrvcA has been added to the local admin group.
> > Domainname\SQLSrvcA has been added as a top level Sharepoint Site
> > Collection
> > Administrator, and Full Control, Design, Contribute, Read rights.
> > In SQL Server, domainname\SQLSrvcA is dbo for the reportserver db, the
> > reportservertemp db, on the reportservertemp db this acct also has
> > RSExecRole
> > rights. This account is also dbo for the SharePoint_AdminContent db,
> > public
> > and WSS_Content_Application_Pools rights to the Sharepoint_Config db, dbo
> > for
> > the SharepointContent db.
> >
> > The SQL Server properties are set for both SQL and Windows authentication.
> > SQL2005 Surface Area Feature Config shows Windows Integrated Security
> > enabled. (have also tested with it disabled and had the same results).
> >
> >
> > I did use the "default website", but changed the port to 8080. Going to
> > http:/servername:8080/reportserver works.
> >
> > In IIS, looking at the properties for the default website, Anonymous
> > access
> > is not enabled, and integrated windows authentication is on.
> >
> >
> > I am working on building this Shareoint site out as a portal. Folks will
> > only be able to get to it from within our domain. I want them to be able
> > to
> > go straight to sharepoint without logging in (which was working before I
> > installed Reporting services). I then want them to be able to pick reports
> > and run them without any further authentication requests.
> >
> > Thank you all for any assistance you can provide.
> > Shirley
> >
> >
>
>|||Let's back up and make sure you have RS installed properly. Even without any
report deployed you should be able to get to the reportserver. Make sure
that works for you:
http://yourserver/Reports/Pages/Folder.aspx
Does this come up?
Also, do you have a fixed IP address for the server?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
news:153C26DD-55A7-4442-9EDE-28D5A7A11393@.microsoft.com...
>I have put in my own account (which is a domain admin acct, and a local
>admin
> acct) but it still doesn't take it, it just blinks and gives me the dialog
> box back.
>
> "Bruce L-C [MVP]" wrote:
>> With integrated security it is looking for you (when deploying). Is your
>> account setup in the local administrators group on the server?
>> Also, I recommend against using linked servers. There is no need to do
>> this.
>> Instead you have the data source setup to the server you want to pull the
>> data from.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
>> news:893DF211-DEE7-4E99-9FB4-FDA8C47585FD@.microsoft.com...
>> > Recently setup my first Sharepoint (wss 3.0, sp2) site including
>> > integrated
>> > Report Services. I have SQL Server 2005 (full version, not the express
>> > version) installed on the same computer. I think I did a farm
>> > install,
>> > but
>> > installed everything on one computer. I do plan on using some linked
>> > servers
>> > to this 2005 box to pull in data from elsewhere. My report views
>> > perfectly
>> > in SQLServer Business Intelligence Dev.
>> >
>> > I must have accounts set up wrong somewhere, because when I go to
>> > deploy a
>> > report it keeps popping up a Reporting Services Login Dialog box. No
>> > matter
>> > what account I put in, or in what format (with or without the domain
>> > portion
>> > of the account) it just blinks and comes back to the reporting services
>> > login
>> > dialog box.
>> >
>> > When I try uploading from Sharepoint into the doc lib,
>> > I have searched through other similar sounding posts, and through the
>> > documentation and I can't figure this one out.
>> >
>> > Here is some pertinent info:
>> > In Reporting Services Configuration Manager:
>> > Windows Service Identity: The service Account is set to a domain acct
>> > (domainname\SQLSrvcA), and Windows acct is selected, with the same acct
>> > name
>> > specified.
>> > Web Service identity: ASP.Net Service Acct = (tried both NT
>> > Authority\Network Service and with domainname\SQLSrvcA)
>> > Database Setup: Credential type is Windows Credentials, with the
>> > account
>> > name: domainname\SQLSrvcA
>> >
>> >
>> > The link on the Sharepoint Integration page works.
>> > I do not have Kerberos setup. Using NTLM.
>> > Anonymous Access is turned off.
>> > Domainname\SQLSrvcA has been added to the local admin group.
>> > Domainname\SQLSrvcA has been added as a top level Sharepoint Site
>> > Collection
>> > Administrator, and Full Control, Design, Contribute, Read rights.
>> > In SQL Server, domainname\SQLSrvcA is dbo for the reportserver db, the
>> > reportservertemp db, on the reportservertemp db this acct also has
>> > RSExecRole
>> > rights. This account is also dbo for the SharePoint_AdminContent db,
>> > public
>> > and WSS_Content_Application_Pools rights to the Sharepoint_Config db,
>> > dbo
>> > for
>> > the SharepointContent db.
>> >
>> > The SQL Server properties are set for both SQL and Windows
>> > authentication.
>> > SQL2005 Surface Area Feature Config shows Windows Integrated Security
>> > enabled. (have also tested with it disabled and had the same results).
>> >
>> >
>> > I did use the "default website", but changed the port to 8080. Going
>> > to
>> > http:/servername:8080/reportserver works.
>> >
>> > In IIS, looking at the properties for the default website, Anonymous
>> > access
>> > is not enabled, and integrated windows authentication is on.
>> >
>> >
>> > I am working on building this Shareoint site out as a portal. Folks
>> > will
>> > only be able to get to it from within our domain. I want them to be
>> > able
>> > to
>> > go straight to sharepoint without logging in (which was working before
>> > I
>> > installed Reporting services). I then want them to be able to pick
>> > reports
>> > and run them without any further authentication requests.
>> >
>> > Thank you all for any assistance you can provide.
>> > Shirley
>> >
>> >
>>|||"Going
>> > to
>> > http:/servername:8080/reportserver works." And I can browse into a list of folders that are from various Sharepoint sites under our top level sites.
"Bruce L-C [MVP]" wrote:
> Let's back up and make sure you have RS installed properly. Even without any
> report deployed you should be able to get to the reportserver. Make sure
> that works for you:
> http://yourserver/Reports/Pages/Folder.aspx
> Does this come up?
> Also, do you have a fixed IP address for the server?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
> news:153C26DD-55A7-4442-9EDE-28D5A7A11393@.microsoft.com...
> >I have put in my own account (which is a domain admin acct, and a local
> >admin
> > acct) but it still doesn't take it, it just blinks and gives me the dialog
> > box back.
> >
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> With integrated security it is looking for you (when deploying). Is your
> >> account setup in the local administrators group on the server?
> >>
> >> Also, I recommend against using linked servers. There is no need to do
> >> this.
> >> Instead you have the data source setup to the server you want to pull the
> >> data from.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
> >> news:893DF211-DEE7-4E99-9FB4-FDA8C47585FD@.microsoft.com...
> >> > Recently setup my first Sharepoint (wss 3.0, sp2) site including
> >> > integrated
> >> > Report Services. I have SQL Server 2005 (full version, not the express
> >> > version) installed on the same computer. I think I did a farm
> >> > install,
> >> > but
> >> > installed everything on one computer. I do plan on using some linked
> >> > servers
> >> > to this 2005 box to pull in data from elsewhere. My report views
> >> > perfectly
> >> > in SQLServer Business Intelligence Dev.
> >> >
> >> > I must have accounts set up wrong somewhere, because when I go to
> >> > deploy a
> >> > report it keeps popping up a Reporting Services Login Dialog box. No
> >> > matter
> >> > what account I put in, or in what format (with or without the domain
> >> > portion
> >> > of the account) it just blinks and comes back to the reporting services
> >> > login
> >> > dialog box.
> >> >
> >> > When I try uploading from Sharepoint into the doc lib,
> >> > I have searched through other similar sounding posts, and through the
> >> > documentation and I can't figure this one out.
> >> >
> >> > Here is some pertinent info:
> >> > In Reporting Services Configuration Manager:
> >> > Windows Service Identity: The service Account is set to a domain acct
> >> > (domainname\SQLSrvcA), and Windows acct is selected, with the same acct
> >> > name
> >> > specified.
> >> > Web Service identity: ASP.Net Service Acct = (tried both NT
> >> > Authority\Network Service and with domainname\SQLSrvcA)
> >> > Database Setup: Credential type is Windows Credentials, with the
> >> > account
> >> > name: domainname\SQLSrvcA
> >> >
> >> >
> >> > The link on the Sharepoint Integration page works.
> >> > I do not have Kerberos setup. Using NTLM.
> >> > Anonymous Access is turned off.
> >> > Domainname\SQLSrvcA has been added to the local admin group.
> >> > Domainname\SQLSrvcA has been added as a top level Sharepoint Site
> >> > Collection
> >> > Administrator, and Full Control, Design, Contribute, Read rights.
> >> > In SQL Server, domainname\SQLSrvcA is dbo for the reportserver db, the
> >> > reportservertemp db, on the reportservertemp db this acct also has
> >> > RSExecRole
> >> > rights. This account is also dbo for the SharePoint_AdminContent db,
> >> > public
> >> > and WSS_Content_Application_Pools rights to the Sharepoint_Config db,
> >> > dbo
> >> > for
> >> > the SharepointContent db.
> >> >
> >> > The SQL Server properties are set for both SQL and Windows
> >> > authentication.
> >> > SQL2005 Surface Area Feature Config shows Windows Integrated Security
> >> > enabled. (have also tested with it disabled and had the same results).
> >> >
> >> >
> >> > I did use the "default website", but changed the port to 8080. Going
> >> > to
> >> > http:/servername:8080/reportserver works.
> >> >
> >> > In IIS, looking at the properties for the default website, Anonymous
> >> > access
> >> > is not enabled, and integrated windows authentication is on.
> >> >
> >> >
> >> > I am working on building this Shareoint site out as a portal. Folks
> >> > will
> >> > only be able to get to it from within our domain. I want them to be
> >> > able
> >> > to
> >> > go straight to sharepoint without logging in (which was working before
> >> > I
> >> > installed Reporting services). I then want them to be able to pick
> >> > reports
> >> > and run them without any further authentication requests.
> >> >
> >> > Thank you all for any assistance you can provide.
> >> > Shirley
> >> >
> >> >
> >>
> >>
> >>
>
>|||reportserver is the RS application itself. However, just seeing the folder
list this way is not a good test. Report Manager is the portal that ships
with RS. Make sure this works for you.
http://yourserver/Reports/Pages/Folder.aspx
One other thing. Have you configured your VS project on where you are
supposed to deploy to?
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
news:79639F43-3296-44E9-840B-F34977F2F77F@.microsoft.com...
> "Going
>> > to
>> > http:/servername:8080/reportserver works." And I can browse into a
>> > list of folders that are from various Sharepoint sites under our top
>> > level sites.
>
> "Bruce L-C [MVP]" wrote:
>> Let's back up and make sure you have RS installed properly. Even without
>> any
>> report deployed you should be able to get to the reportserver. Make sure
>> that works for you:
>> http://yourserver/Reports/Pages/Folder.aspx
>> Does this come up?
>> Also, do you have a fixed IP address for the server?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
>> news:153C26DD-55A7-4442-9EDE-28D5A7A11393@.microsoft.com...
>> >I have put in my own account (which is a domain admin acct, and a local
>> >admin
>> > acct) but it still doesn't take it, it just blinks and gives me the
>> > dialog
>> > box back.
>> >
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> With integrated security it is looking for you (when deploying). Is
>> >> your
>> >> account setup in the local administrators group on the server?
>> >>
>> >> Also, I recommend against using linked servers. There is no need to do
>> >> this.
>> >> Instead you have the data source setup to the server you want to pull
>> >> the
>> >> data from.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
>> >> news:893DF211-DEE7-4E99-9FB4-FDA8C47585FD@.microsoft.com...
>> >> > Recently setup my first Sharepoint (wss 3.0, sp2) site including
>> >> > integrated
>> >> > Report Services. I have SQL Server 2005 (full version, not the
>> >> > express
>> >> > version) installed on the same computer. I think I did a farm
>> >> > install,
>> >> > but
>> >> > installed everything on one computer. I do plan on using some
>> >> > linked
>> >> > servers
>> >> > to this 2005 box to pull in data from elsewhere. My report views
>> >> > perfectly
>> >> > in SQLServer Business Intelligence Dev.
>> >> >
>> >> > I must have accounts set up wrong somewhere, because when I go to
>> >> > deploy a
>> >> > report it keeps popping up a Reporting Services Login Dialog box. No
>> >> > matter
>> >> > what account I put in, or in what format (with or without the domain
>> >> > portion
>> >> > of the account) it just blinks and comes back to the reporting
>> >> > services
>> >> > login
>> >> > dialog box.
>> >> >
>> >> > When I try uploading from Sharepoint into the doc lib,
>> >> > I have searched through other similar sounding posts, and through
>> >> > the
>> >> > documentation and I can't figure this one out.
>> >> >
>> >> > Here is some pertinent info:
>> >> > In Reporting Services Configuration Manager:
>> >> > Windows Service Identity: The service Account is set to a domain
>> >> > acct
>> >> > (domainname\SQLSrvcA), and Windows acct is selected, with the same
>> >> > acct
>> >> > name
>> >> > specified.
>> >> > Web Service identity: ASP.Net Service Acct = (tried both NT
>> >> > Authority\Network Service and with domainname\SQLSrvcA)
>> >> > Database Setup: Credential type is Windows Credentials, with the
>> >> > account
>> >> > name: domainname\SQLSrvcA
>> >> >
>> >> >
>> >> > The link on the Sharepoint Integration page works.
>> >> > I do not have Kerberos setup. Using NTLM.
>> >> > Anonymous Access is turned off.
>> >> > Domainname\SQLSrvcA has been added to the local admin group.
>> >> > Domainname\SQLSrvcA has been added as a top level Sharepoint Site
>> >> > Collection
>> >> > Administrator, and Full Control, Design, Contribute, Read rights.
>> >> > In SQL Server, domainname\SQLSrvcA is dbo for the reportserver db,
>> >> > the
>> >> > reportservertemp db, on the reportservertemp db this acct also has
>> >> > RSExecRole
>> >> > rights. This account is also dbo for the SharePoint_AdminContent
>> >> > db,
>> >> > public
>> >> > and WSS_Content_Application_Pools rights to the Sharepoint_Config
>> >> > db,
>> >> > dbo
>> >> > for
>> >> > the SharepointContent db.
>> >> >
>> >> > The SQL Server properties are set for both SQL and Windows
>> >> > authentication.
>> >> > SQL2005 Surface Area Feature Config shows Windows Integrated
>> >> > Security
>> >> > enabled. (have also tested with it disabled and had the same
>> >> > results).
>> >> >
>> >> >
>> >> > I did use the "default website", but changed the port to 8080.
>> >> > Going
>> >> > to
>> >> > http:/servername:8080/reportserver works.
>> >> >
>> >> > In IIS, looking at the properties for the default website, Anonymous
>> >> > access
>> >> > is not enabled, and integrated windows authentication is on.
>> >> >
>> >> >
>> >> > I am working on building this Shareoint site out as a portal. Folks
>> >> > will
>> >> > only be able to get to it from within our domain. I want them to be
>> >> > able
>> >> > to
>> >> > go straight to sharepoint without logging in (which was working
>> >> > before
>> >> > I
>> >> > installed Reporting services). I then want them to be able to pick
>> >> > reports
>> >> > and run them without any further authentication requests.
>> >> >
>> >> > Thank you all for any assistance you can provide.
>> >> > Shirley
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>|||My understanding is that once you install RS in Sharepoint integrated mode,
that Report Manager is no longer accessible. That RS management is only
accessible via Sharepoint.
?
Shirley
"Bruce L-C [MVP]" wrote:
> reportserver is the RS application itself. However, just seeing the folder
> list this way is not a good test. Report Manager is the portal that ships
> with RS. Make sure this works for you.
> http://yourserver/Reports/Pages/Folder.aspx
> One other thing. Have you configured your VS project on where you are
> supposed to deploy to?
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
> news:79639F43-3296-44E9-840B-F34977F2F77F@.microsoft.com...
> > "Going
> >> > to
> >> > http:/servername:8080/reportserver works." And I can browse into a
> >> > list of folders that are from various Sharepoint sites under our top
> >> > level sites.
> >
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Let's back up and make sure you have RS installed properly. Even without
> >> any
> >> report deployed you should be able to get to the reportserver. Make sure
> >> that works for you:
> >>
> >> http://yourserver/Reports/Pages/Folder.aspx
> >>
> >> Does this come up?
> >>
> >> Also, do you have a fixed IP address for the server?
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
> >> news:153C26DD-55A7-4442-9EDE-28D5A7A11393@.microsoft.com...
> >> >I have put in my own account (which is a domain admin acct, and a local
> >> >admin
> >> > acct) but it still doesn't take it, it just blinks and gives me the
> >> > dialog
> >> > box back.
> >> >
> >> >
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> With integrated security it is looking for you (when deploying). Is
> >> >> your
> >> >> account setup in the local administrators group on the server?
> >> >>
> >> >> Also, I recommend against using linked servers. There is no need to do
> >> >> this.
> >> >> Instead you have the data source setup to the server you want to pull
> >> >> the
> >> >> data from.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
> >> >> news:893DF211-DEE7-4E99-9FB4-FDA8C47585FD@.microsoft.com...
> >> >> > Recently setup my first Sharepoint (wss 3.0, sp2) site including
> >> >> > integrated
> >> >> > Report Services. I have SQL Server 2005 (full version, not the
> >> >> > express
> >> >> > version) installed on the same computer. I think I did a farm
> >> >> > install,
> >> >> > but
> >> >> > installed everything on one computer. I do plan on using some
> >> >> > linked
> >> >> > servers
> >> >> > to this 2005 box to pull in data from elsewhere. My report views
> >> >> > perfectly
> >> >> > in SQLServer Business Intelligence Dev.
> >> >> >
> >> >> > I must have accounts set up wrong somewhere, because when I go to
> >> >> > deploy a
> >> >> > report it keeps popping up a Reporting Services Login Dialog box. No
> >> >> > matter
> >> >> > what account I put in, or in what format (with or without the domain
> >> >> > portion
> >> >> > of the account) it just blinks and comes back to the reporting
> >> >> > services
> >> >> > login
> >> >> > dialog box.
> >> >> >
> >> >> > When I try uploading from Sharepoint into the doc lib,
> >> >> > I have searched through other similar sounding posts, and through
> >> >> > the
> >> >> > documentation and I can't figure this one out.
> >> >> >
> >> >> > Here is some pertinent info:
> >> >> > In Reporting Services Configuration Manager:
> >> >> > Windows Service Identity: The service Account is set to a domain
> >> >> > acct
> >> >> > (domainname\SQLSrvcA), and Windows acct is selected, with the same
> >> >> > acct
> >> >> > name
> >> >> > specified.
> >> >> > Web Service identity: ASP.Net Service Acct = (tried both NT
> >> >> > Authority\Network Service and with domainname\SQLSrvcA)
> >> >> > Database Setup: Credential type is Windows Credentials, with the
> >> >> > account
> >> >> > name: domainname\SQLSrvcA
> >> >> >
> >> >> >
> >> >> > The link on the Sharepoint Integration page works.
> >> >> > I do not have Kerberos setup. Using NTLM.
> >> >> > Anonymous Access is turned off.
> >> >> > Domainname\SQLSrvcA has been added to the local admin group.
> >> >> > Domainname\SQLSrvcA has been added as a top level Sharepoint Site
> >> >> > Collection
> >> >> > Administrator, and Full Control, Design, Contribute, Read rights.
> >> >> > In SQL Server, domainname\SQLSrvcA is dbo for the reportserver db,
> >> >> > the
> >> >> > reportservertemp db, on the reportservertemp db this acct also has
> >> >> > RSExecRole
> >> >> > rights. This account is also dbo for the SharePoint_AdminContent
> >> >> > db,
> >> >> > public
> >> >> > and WSS_Content_Application_Pools rights to the Sharepoint_Config
> >> >> > db,
> >> >> > dbo
> >> >> > for
> >> >> > the SharepointContent db.
> >> >> >
> >> >> > The SQL Server properties are set for both SQL and Windows
> >> >> > authentication.
> >> >> > SQL2005 Surface Area Feature Config shows Windows Integrated
> >> >> > Security
> >> >> > enabled. (have also tested with it disabled and had the same
> >> >> > results).
> >> >> >
> >> >> >
> >> >> > I did use the "default website", but changed the port to 8080.
> >> >> > Going
> >> >> > to
> >> >> > http:/servername:8080/reportserver works.
> >> >> >
> >> >> > In IIS, looking at the properties for the default website, Anonymous
> >> >> > access
> >> >> > is not enabled, and integrated windows authentication is on.
> >> >> >
> >> >> >
> >> >> > I am working on building this Shareoint site out as a portal. Folks
> >> >> > will
> >> >> > only be able to get to it from within our domain. I want them to be
> >> >> > able
> >> >> > to
> >> >> > go straight to sharepoint without logging in (which was working
> >> >> > before
> >> >> > I
> >> >> > installed Reporting services). I then want them to be able to pick
> >> >> > reports
> >> >> > and run them without any further authentication requests.
> >> >> >
> >> >> > Thank you all for any assistance you can provide.
> >> >> > Shirley
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||I have attempted accessing the link/path you suggested and get the following:
"The operation is not supported on a report server that is configured to run
in Sharepoint integrated mode."
"ShirleyH" wrote:
> My understanding is that once you install RS in Sharepoint integrated mode,
> that Report Manager is no longer accessible. That RS management is only
> accessible via Sharepoint.
> ?
> Shirley
> "Bruce L-C [MVP]" wrote:
> > reportserver is the RS application itself. However, just seeing the folder
> > list this way is not a good test. Report Manager is the portal that ships
> > with RS. Make sure this works for you.
> >
> > http://yourserver/Reports/Pages/Folder.aspx
> >
> > One other thing. Have you configured your VS project on where you are
> > supposed to deploy to?
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> >
> > "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
> > news:79639F43-3296-44E9-840B-F34977F2F77F@.microsoft.com...
> > > "Going
> > >> > to
> > >> > http:/servername:8080/reportserver works." And I can browse into a
> > >> > list of folders that are from various Sharepoint sites under our top
> > >> > level sites.
> > >
> > >
> > >
> > > "Bruce L-C [MVP]" wrote:
> > >
> > >> Let's back up and make sure you have RS installed properly. Even without
> > >> any
> > >> report deployed you should be able to get to the reportserver. Make sure
> > >> that works for you:
> > >>
> > >> http://yourserver/Reports/Pages/Folder.aspx
> > >>
> > >> Does this come up?
> > >>
> > >> Also, do you have a fixed IP address for the server?
> > >>
> > >>
> > >> --
> > >> Bruce Loehle-Conger
> > >> MVP SQL Server Reporting Services
> > >>
> > >> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
> > >> news:153C26DD-55A7-4442-9EDE-28D5A7A11393@.microsoft.com...
> > >> >I have put in my own account (which is a domain admin acct, and a local
> > >> >admin
> > >> > acct) but it still doesn't take it, it just blinks and gives me the
> > >> > dialog
> > >> > box back.
> > >> >
> > >> >
> > >> >
> > >> > "Bruce L-C [MVP]" wrote:
> > >> >
> > >> >> With integrated security it is looking for you (when deploying). Is
> > >> >> your
> > >> >> account setup in the local administrators group on the server?
> > >> >>
> > >> >> Also, I recommend against using linked servers. There is no need to do
> > >> >> this.
> > >> >> Instead you have the data source setup to the server you want to pull
> > >> >> the
> > >> >> data from.
> > >> >>
> > >> >>
> > >> >> --
> > >> >> Bruce Loehle-Conger
> > >> >> MVP SQL Server Reporting Services
> > >> >>
> > >> >> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
> > >> >> news:893DF211-DEE7-4E99-9FB4-FDA8C47585FD@.microsoft.com...
> > >> >> > Recently setup my first Sharepoint (wss 3.0, sp2) site including
> > >> >> > integrated
> > >> >> > Report Services. I have SQL Server 2005 (full version, not the
> > >> >> > express
> > >> >> > version) installed on the same computer. I think I did a farm
> > >> >> > install,
> > >> >> > but
> > >> >> > installed everything on one computer. I do plan on using some
> > >> >> > linked
> > >> >> > servers
> > >> >> > to this 2005 box to pull in data from elsewhere. My report views
> > >> >> > perfectly
> > >> >> > in SQLServer Business Intelligence Dev.
> > >> >> >
> > >> >> > I must have accounts set up wrong somewhere, because when I go to
> > >> >> > deploy a
> > >> >> > report it keeps popping up a Reporting Services Login Dialog box. No
> > >> >> > matter
> > >> >> > what account I put in, or in what format (with or without the domain
> > >> >> > portion
> > >> >> > of the account) it just blinks and comes back to the reporting
> > >> >> > services
> > >> >> > login
> > >> >> > dialog box.
> > >> >> >
> > >> >> > When I try uploading from Sharepoint into the doc lib,
> > >> >> > I have searched through other similar sounding posts, and through
> > >> >> > the
> > >> >> > documentation and I can't figure this one out.
> > >> >> >
> > >> >> > Here is some pertinent info:
> > >> >> > In Reporting Services Configuration Manager:
> > >> >> > Windows Service Identity: The service Account is set to a domain
> > >> >> > acct
> > >> >> > (domainname\SQLSrvcA), and Windows acct is selected, with the same
> > >> >> > acct
> > >> >> > name
> > >> >> > specified.
> > >> >> > Web Service identity: ASP.Net Service Acct = (tried both NT
> > >> >> > Authority\Network Service and with domainname\SQLSrvcA)
> > >> >> > Database Setup: Credential type is Windows Credentials, with the
> > >> >> > account
> > >> >> > name: domainname\SQLSrvcA
> > >> >> >
> > >> >> >
> > >> >> > The link on the Sharepoint Integration page works.
> > >> >> > I do not have Kerberos setup. Using NTLM.
> > >> >> > Anonymous Access is turned off.
> > >> >> > Domainname\SQLSrvcA has been added to the local admin group.
> > >> >> > Domainname\SQLSrvcA has been added as a top level Sharepoint Site
> > >> >> > Collection
> > >> >> > Administrator, and Full Control, Design, Contribute, Read rights.
> > >> >> > In SQL Server, domainname\SQLSrvcA is dbo for the reportserver db,
> > >> >> > the
> > >> >> > reportservertemp db, on the reportservertemp db this acct also has
> > >> >> > RSExecRole
> > >> >> > rights. This account is also dbo for the SharePoint_AdminContent
> > >> >> > db,
> > >> >> > public
> > >> >> > and WSS_Content_Application_Pools rights to the Sharepoint_Config
> > >> >> > db,
> > >> >> > dbo
> > >> >> > for
> > >> >> > the SharepointContent db.
> > >> >> >
> > >> >> > The SQL Server properties are set for both SQL and Windows
> > >> >> > authentication.
> > >> >> > SQL2005 Surface Area Feature Config shows Windows Integrated
> > >> >> > Security
> > >> >> > enabled. (have also tested with it disabled and had the same
> > >> >> > results).
> > >> >> >
> > >> >> >
> > >> >> > I did use the "default website", but changed the port to 8080.
> > >> >> > Going
> > >> >> > to
> > >> >> > http:/servername:8080/reportserver works.
> > >> >> >
> > >> >> > In IIS, looking at the properties for the default website, Anonymous
> > >> >> > access
> > >> >> > is not enabled, and integrated windows authentication is on.
> > >> >> >
> > >> >> >
> > >> >> > I am working on building this Shareoint site out as a portal. Folks
> > >> >> > will
> > >> >> > only be able to get to it from within our domain. I want them to be
> > >> >> > able
> > >> >> > to
> > >> >> > go straight to sharepoint without logging in (which was working
> > >> >> > before
> > >> >> > I
> > >> >> > installed Reporting services). I then want them to be able to pick
> > >> >> > reports
> > >> >> > and run them without any further authentication requests.
> > >> >> >
> > >> >> > Thank you all for any assistance you can provide.
> > >> >> > Shirley
> > >> >> >
> > >> >> >
> > >> >>
> > >> >>
> > >> >>
> > >>
> > >>
> > >>
> >
> >
> >|||Ahh, sorry, I didn't realize this (I don't run Sharepoint). This very well
could be a sharepoint / reporting services integration issue.
I'm afraid I can't help you with this. I'm out of ideas.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
news:9E350FCD-D4DE-4E80-9BD9-09EB7ADFF0AA@.microsoft.com...
>I have attempted accessing the link/path you suggested and get the
>following:
> "The operation is not supported on a report server that is configured to
> run
> in Sharepoint integrated mode."
> "ShirleyH" wrote:
>> My understanding is that once you install RS in Sharepoint integrated
>> mode,
>> that Report Manager is no longer accessible. That RS management is only
>> accessible via Sharepoint.
>> ?
>> Shirley
>> "Bruce L-C [MVP]" wrote:
>> > reportserver is the RS application itself. However, just seeing the
>> > folder
>> > list this way is not a good test. Report Manager is the portal that
>> > ships
>> > with RS. Make sure this works for you.
>> >
>> > http://yourserver/Reports/Pages/Folder.aspx
>> >
>> > One other thing. Have you configured your VS project on where you are
>> > supposed to deploy to?
>> >
>> > --
>> > Bruce Loehle-Conger
>> > MVP SQL Server Reporting Services
>> >
>> >
>> >
>> > "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
>> > news:79639F43-3296-44E9-840B-F34977F2F77F@.microsoft.com...
>> > > "Going
>> > >> > to
>> > >> > http:/servername:8080/reportserver works." And I can browse into
>> > >> > a
>> > >> > list of folders that are from various Sharepoint sites under our
>> > >> > top
>> > >> > level sites.
>> > >
>> > >
>> > >
>> > > "Bruce L-C [MVP]" wrote:
>> > >
>> > >> Let's back up and make sure you have RS installed properly. Even
>> > >> without
>> > >> any
>> > >> report deployed you should be able to get to the reportserver. Make
>> > >> sure
>> > >> that works for you:
>> > >>
>> > >> http://yourserver/Reports/Pages/Folder.aspx
>> > >>
>> > >> Does this come up?
>> > >>
>> > >> Also, do you have a fixed IP address for the server?
>> > >>
>> > >>
>> > >> --
>> > >> Bruce Loehle-Conger
>> > >> MVP SQL Server Reporting Services
>> > >>
>> > >> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
>> > >> news:153C26DD-55A7-4442-9EDE-28D5A7A11393@.microsoft.com...
>> > >> >I have put in my own account (which is a domain admin acct, and a
>> > >> >local
>> > >> >admin
>> > >> > acct) but it still doesn't take it, it just blinks and gives me
>> > >> > the
>> > >> > dialog
>> > >> > box back.
>> > >> >
>> > >> >
>> > >> >
>> > >> > "Bruce L-C [MVP]" wrote:
>> > >> >
>> > >> >> With integrated security it is looking for you (when deploying).
>> > >> >> Is
>> > >> >> your
>> > >> >> account setup in the local administrators group on the server?
>> > >> >>
>> > >> >> Also, I recommend against using linked servers. There is no need
>> > >> >> to do
>> > >> >> this.
>> > >> >> Instead you have the data source setup to the server you want to
>> > >> >> pull
>> > >> >> the
>> > >> >> data from.
>> > >> >>
>> > >> >>
>> > >> >> --
>> > >> >> Bruce Loehle-Conger
>> > >> >> MVP SQL Server Reporting Services
>> > >> >>
>> > >> >> "ShirleyH" <ShirleyNOSPAMH@.abshernw.com> wrote in message
>> > >> >> news:893DF211-DEE7-4E99-9FB4-FDA8C47585FD@.microsoft.com...
>> > >> >> > Recently setup my first Sharepoint (wss 3.0, sp2) site
>> > >> >> > including
>> > >> >> > integrated
>> > >> >> > Report Services. I have SQL Server 2005 (full version, not the
>> > >> >> > express
>> > >> >> > version) installed on the same computer. I think I did a farm
>> > >> >> > install,
>> > >> >> > but
>> > >> >> > installed everything on one computer. I do plan on using some
>> > >> >> > linked
>> > >> >> > servers
>> > >> >> > to this 2005 box to pull in data from elsewhere. My report
>> > >> >> > views
>> > >> >> > perfectly
>> > >> >> > in SQLServer Business Intelligence Dev.
>> > >> >> >
>> > >> >> > I must have accounts set up wrong somewhere, because when I go
>> > >> >> > to
>> > >> >> > deploy a
>> > >> >> > report it keeps popping up a Reporting Services Login Dialog
>> > >> >> > box. No
>> > >> >> > matter
>> > >> >> > what account I put in, or in what format (with or without the
>> > >> >> > domain
>> > >> >> > portion
>> > >> >> > of the account) it just blinks and comes back to the reporting
>> > >> >> > services
>> > >> >> > login
>> > >> >> > dialog box.
>> > >> >> >
>> > >> >> > When I try uploading from Sharepoint into the doc lib,
>> > >> >> > I have searched through other similar sounding posts, and
>> > >> >> > through
>> > >> >> > the
>> > >> >> > documentation and I can't figure this one out.
>> > >> >> >
>> > >> >> > Here is some pertinent info:
>> > >> >> > In Reporting Services Configuration Manager:
>> > >> >> > Windows Service Identity: The service Account is set to a
>> > >> >> > domain
>> > >> >> > acct
>> > >> >> > (domainname\SQLSrvcA), and Windows acct is selected, with the
>> > >> >> > same
>> > >> >> > acct
>> > >> >> > name
>> > >> >> > specified.
>> > >> >> > Web Service identity: ASP.Net Service Acct = (tried both NT
>> > >> >> > Authority\Network Service and with domainname\SQLSrvcA)
>> > >> >> > Database Setup: Credential type is Windows Credentials, with
>> > >> >> > the
>> > >> >> > account
>> > >> >> > name: domainname\SQLSrvcA
>> > >> >> >
>> > >> >> >
>> > >> >> > The link on the Sharepoint Integration page works.
>> > >> >> > I do not have Kerberos setup. Using NTLM.
>> > >> >> > Anonymous Access is turned off.
>> > >> >> > Domainname\SQLSrvcA has been added to the local admin group.
>> > >> >> > Domainname\SQLSrvcA has been added as a top level Sharepoint
>> > >> >> > Site
>> > >> >> > Collection
>> > >> >> > Administrator, and Full Control, Design, Contribute, Read
>> > >> >> > rights.
>> > >> >> > In SQL Server, domainname\SQLSrvcA is dbo for the reportserver
>> > >> >> > db,
>> > >> >> > the
>> > >> >> > reportservertemp db, on the reportservertemp db this acct also
>> > >> >> > has
>> > >> >> > RSExecRole
>> > >> >> > rights. This account is also dbo for the
>> > >> >> > SharePoint_AdminContent
>> > >> >> > db,
>> > >> >> > public
>> > >> >> > and WSS_Content_Application_Pools rights to the
>> > >> >> > Sharepoint_Config
>> > >> >> > db,
>> > >> >> > dbo
>> > >> >> > for
>> > >> >> > the SharepointContent db.
>> > >> >> >
>> > >> >> > The SQL Server properties are set for both SQL and Windows
>> > >> >> > authentication.
>> > >> >> > SQL2005 Surface Area Feature Config shows Windows Integrated
>> > >> >> > Security
>> > >> >> > enabled. (have also tested with it disabled and had the same
>> > >> >> > results).
>> > >> >> >
>> > >> >> >
>> > >> >> > I did use the "default website", but changed the port to 8080.
>> > >> >> > Going
>> > >> >> > to
>> > >> >> > http:/servername:8080/reportserver works.
>> > >> >> >
>> > >> >> > In IIS, looking at the properties for the default website,
>> > >> >> > Anonymous
>> > >> >> > access
>> > >> >> > is not enabled, and integrated windows authentication is on.
>> > >> >> >
>> > >> >> >
>> > >> >> > I am working on building this Shareoint site out as a portal.
>> > >> >> > Folks
>> > >> >> > will
>> > >> >> > only be able to get to it from within our domain. I want them
>> > >> >> > to be
>> > >> >> > able
>> > >> >> > to
>> > >> >> > go straight to sharepoint without logging in (which was working
>> > >> >> > before
>> > >> >> > I
>> > >> >> > installed Reporting services). I then want them to be able to
>> > >> >> > pick
>> > >> >> > reports
>> > >> >> > and run them without any further authentication requests.
>> > >> >> >
>> > >> >> > Thank you all for any assistance you can provide.
>> > >> >> > Shirley
>> > >> >> >
>> > >> >> >
>> > >> >>
>> > >> >>
>> > >> >>
>> > >>
>> > >>
>> > >>
>> >
>> >
>> >|||having the same issue with same set-up type credentials for the admin
in SharePoint and SQL... known issue, but was wondering if you had
anyone help you resolve it|||"Juan.Carlos.Novoa@.gmail.com" wrote:
> having the same issue with same set-up type credentials for the admin
> in SharePoint and SQL... known issue, but was wondering if you had
> anyone help you resolve it
>
I am also having the smae issue. Has there been any solution determined on
this?

Deploying multi-user sql express database to SQL Express Server

Okay, I've read massive topics on ClickOnce, and embedded database applications, etc, etc.

I need a handful of good suggestions how I can create a deployment package, to get my sql express database onto a SQL Express server.

The database will need to be multi-user, because I am also developing a WinForms application to connect to the SQL Express database.

I'm thinking I need to use some automated scripting features, to generate scripts for the database once I am done (unless you have a better suggestion).

After that, I need to know what to do with those scripts, and how can I create a setup / deployment packages to run those scripts against a SQL Express server.

The other alterntative obviously is to copy my sql express database, and run an attach command. This will work the first time, only because this will have been the first deployment of this database.

Please keep in mind when answering this question, that I will not be embedding the database, and as far as I understand ClickOnce is a feature for use with embedded databases or user instance databases (not sure).

Daniel Crane

Ping!

Is anybody reading these posts?

|||

Dan,

You may find these sources useful.

SQL Server 2005 UnAttended Installations
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
http://msdn2.microsoft.com/en-us/library/bb264562.aspx
http://www.devx.com/dbzone/Article/31648

|||

Hmmm... Thanks Arnie this information is helpful to a degree.

I was hoping to get more information on how to create an automated installation, like Microsoft does, when distributing database samples. Something I could just run on a SQL Server, and have the installation "install" the database.

Right now, if I want to do something similar with an application installation. I would create a VB.net project, write the code, test, etc. Then I would create a deployment package.

What would I do if I want to have a "database" project. Am not referring to the actual Database project in VS.NET Pro. I want to be able to create a database, probably script it out entirely, then create an "installation" package.

Right now all the info I have says buy a 3rd party tool, because Microsoft stuff doesn't give us the ability to do this, unless it's a user-instance express database (which is not the same as multi-user).

that's a bit frustrating, because I am a one man shop, and would like to be able to manage larger projects for my customers. Without having to buy Team Enterprise for Database Developers (or whatever it's called). I love Microsoft, but they seem to keep the single person, or small team from having access to the tools that we really need, unless we are willing to pay the same price as huge corporations.

I've found a relatively low cost tool called EasySql Deployment, but I was hoping to do it "the Microsoft way". Please let me know if you have any additional suggestion, because I do appreciate the input!!

Thanks again!

|||

OK, digging a little deeper, perhaps these are more to your needs.

Deploy Database with MSI
http://msdn.microsoft.com/msdnmag/issues/04/09/customdatabaseinstaller/

Deploy Database with Application

http://www.codeproject.com/useritems/Deploy_your_database.asp

|||

Thanks for that extra info! The CodeProject article really helps!

Deploying MSSQL 2005 Express DB to MSSQL 2005 WKGP Errors

DB is developed on local computer with MSSQL 2005 Express. My host is on MSSQL 2005 workgroup. Are they compatible, because I am getting errors? Is my approach wrong?

I have tried several approaches.

A) I created a backup of database on my local, then placed a copy on the server. Then I tried to restore through Server Management Studio. I get this error.

TITLE: Microsoft SQL Server Management Studio

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

ADDITIONAL INFORMATION:

The backed-up database has on-disk structure version 611. The server supports version 539 and cannot restore or upgrade this database.

RESTORE FILELIST is terminating abnormally. (Microsoft SQL Server, Error: 3169)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.2039&EvtSrc=MSSQLServer&EvtID=3169&LinkId=20476

BUTTONS:

OK

B: I also have tried copying the database. I put it in the same path as the other databases that can be read with server management studio on the server. Then, tried to get to it through server managements studio and it did not appear. So I tried to attach it. Then I received this error:

TITLE: Microsoft SQL Server Management Studio

Attach database failed for Server 'MROACH1'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Could not find row in sysindexes for database ID 10, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.

Could not open new database 'LodgingDB'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=602&LinkId=20476

BUTTONS:

OK

C: I have also tried opening the Database, and back up file through Server Management Studio. without success.

D: I also tried Windows and Software update at microsoft update, but no updates were recommended for Version on Server.

I'm surprised this is so hard. My original data base was created in same family of software. 2005 MS SQL Express. I could use some direct help from someone experienced with this. Am I doing it wrong or are the DB versions incompatible.

Mark Roach

Hi Mark,

The first error you mention would indicate that your hosting company is using SQL 2000 not SQL 2005. Database files are not backward compatible. You should verify with your host what version of SQL Server they have, or if they have both 2000 and 2005, that they are pointing you to a 2005 server.

Mike

|||

Thanks Mike,

The host machine is on MSSQL 2005 WorkGroup.

|||

Actually, you may be incorrect about what is running on the hosting system.

The error message from the restore:

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.2039&EvtSrc=MSSQLServer&EvtID=3169&LinkId=20476

indicates (ProdVer=08.00.2039) that it is running SQL 2000, not SQL 2005. Also, the error message talking about versions of databases indicates the same.

All SKUs/editions of SQL databases of the same version are compatible. There are no diffences in database format between Express and Workgroup as long as both are the same version.

|||

Hi there,

I got the same error when I tried to restore the SQL 2005 DB to SQL 2005 DB.

Were you able to figure this one out? If so, could you please let me know?

Thanks in advance,

SG.

Deploying MSSQL 2005 Express DB to MSSQL 2005 WKGP Errors

DB is developed on local computer with MSSQL 2005 Express. My host is on MSSQL 2005 workgroup. Are they compatible, because I am getting errors? Is my approach wrong?

I have tried several approaches.

A) I created a backup of database on my local, then placed a copy on the server. Then I tried to restore through Server Management Studio. I get this error.

TITLE: Microsoft SQL Server Management Studio

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

ADDITIONAL INFORMATION:

The backed-up database has on-disk structure version 611. The server supports version 539 and cannot restore or upgrade this database.

RESTORE FILELIST is terminating abnormally. (Microsoft SQL Server, Error: 3169)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.2039&EvtSrc=MSSQLServer&EvtID=3169&LinkId=20476

BUTTONS:

OK

B: I also have tried copying the database. I put it in the same path as the other databases that can be read with server management studio on the server. Then, tried to get to it through server managements studio and it did not appear. So I tried to attach it. Then I received this error:

TITLE: Microsoft SQL Server Management Studio

Attach database failed for Server 'MROACH1'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Could not find row in sysindexes for database ID 10, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.

Could not open new database 'LodgingDB'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=602&LinkId=20476

BUTTONS:

OK

C: I have also tried opening the Database, and back up file through Server Management Studio. without success.

D: I also tried Windows and Software update at microsoft update, but no updates were recommended for Version on Server.

I'm surprised this is so hard. My original data base was created in same family of software. 2005 MS SQL Express. I could use some direct help from someone experienced with this. Am I doing it wrong or are the DB versions incompatible.

Mark Roach

Hi Mark,

The first error you mention would indicate that your hosting company is using SQL 2000 not SQL 2005. Database files are not backward compatible. You should verify with your host what version of SQL Server they have, or if they have both 2000 and 2005, that they are pointing you to a 2005 server.

Mike

|||

Thanks Mike,

The host machine is on MSSQL 2005 WorkGroup.

|||

Actually, you may be incorrect about what is running on the hosting system.

The error message from the restore:

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.2039&EvtSrc=MSSQLServer&EvtID=3169&LinkId=20476

indicates (ProdVer=08.00.2039) that it is running SQL 2000, not SQL 2005. Also, the error message talking about versions of databases indicates the same.

All SKUs/editions of SQL databases of the same version are compatible. There are no diffences in database format between Express and Workgroup as long as both are the same version.

|||

Hi there,

I got the same error when I tried to restore the SQL 2005 DB to SQL 2005 DB.

Were you able to figure this one out? If so, could you please let me know?

Thanks in advance,

SG.

Deploying database with .NET assemblies?

We're going to release a .NET 2.0 application soon (3-4 months) that uses SQL Express 2005 as the backend. We'd like to write some of our SPROC in C# (for obvious reasons!). Our .NET 2.0 app will be deployed using ClickOnce and each customer will have one instance of SQL 2005 Express installed locally.
Is there a way for be to deploy the database with all the C# SPROC "embedded" in it, or I'll have to register assemblies individually? I'm concerned about registering assemblies during installation, especially since we're deploying the application using ClickOnce (but not the database).
Also, from time to time, we need to add stored procedure or modify existing ones. In the "old" .NET 1.1 days, it was easy to do this. We had an assembly which main purpose was to update the database structure and SPROC with simple T-SQL commands (ie: ALTER PROCEDURE). Is there a way for us to achieve something similar with our application if we use C# SPROC?
Another concern I have is that the SQL database will most likely NOT be installed on the same machine as the client application (it will be installed on a server). Sending T-SQL queries worked fine with this scenario before, but now that things have changed, I'd like to know how to achieve such a thing.
Thanks for your help!
Carl
PS: any good book on Yukon out there yet? I can't find any!
Carl,

The best book out there on SQL Server 2005 is "A First Look at SQL Server 2005 for Developers" by Bob Beauchemin, Niels Berglund and Dan Sullivan.

To reload a new version of the assembly, using ALTER ASSEMBLY will work as long as the existing sprocs/functions have the same method signatures.

Deploying the database with the sprocs embedded is no problem. They are just held in varbinary form in a database level system table.

HTH,
Christian|||Christian,
Thanks for your answer! I looked into the Beauchemin's book on Amazon a few days ago and it looks interresting. What is holding me a little is that it's based on a 1 year old beta. Things have probably changed a lot since and might also change again for RTM.
About ALTER ASSEMBLY, do you know if it's possible to ADD managed procedures, functions or modify the signatures in some way? Also, do I need to use ALTER ASSEMBLY from the server machine or it could also work remotely? I assume it would, but I think I'm missing pieces of how this new managed SQL works right now...
Thanks a lot again!
Carl
|||

Carl Mercier wrote:

Christian,
Thanks for your answer! I looked into the Beauchemin's book on Amazon a few days ago and it looks interresting. What is holding me a little is that it's based on a 1 year old beta. Things have probably changed a lot since and might also change again for RTM.

As a co-author of the book, I can definitely say it is interesting :-). Yes, it is based on a one year old beta, and much have changed. However, we do have an errata page as well as a page for changes, so you'll always be able to see the latest info.

Carl Mercier wrote:

About ALTER ASSEMBLY, do you know if it's possible to ADD managed procedures, functions or modify the signatures in some way? Also, do I need to use ALTER ASSEMBLY from the server machine or it could also work remotely? I assume it would, but I think I'm missing pieces of how this new managed SQL works right now...

Sure you can add managed procedures, after running ALTER ASSEMBLY you just run CREATE FUNCTION/PROCEDURE/TRIGGER against your new methods. You are NOT allowed to modify signatures.
ALTER will work remotely, BUT; notice that the SqlServer project (which are used to create assemblies for SQL Server) in Visual Studio does not have functionality for ALTER assembly. That's one of the reasons I created my "yukondeployment" MSBUILD tasks and templates for Visual Studio. You can download it and read more about it here.
Niels|||Thanks for your help! I will definately check out Yukon Deployment!
I didn't know you were co-author of the book. I thought you deserved one more sale so I went ahead and ordered the book. Hope it arrives in time for my vacation! I'll read it on the beach in a few days! I hope this sale will at least buy you a cold one.
Your help is appreciated!
Carl

deploying App to 2003 server with SQL2005

I devloped this app with vs2005 and SQL 2005 express, everything seems to work fine, when I deploied the app to my web server I got a few different error messages that I worked through but now stuck on this one. i am sure it is something with SQL 2005 server. is there anywhere that has a good check list for doing things right in asp and SQL deployment?

here is the error message i am getting from debugging.

The SELECT permission was denied on the object 'Categories', database 'Blog', schema 'dbo'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: The SELECT permission was denied on the object 'Categories', database 'Blog', schema 'dbo'.

Source Error:

Line 33: SqlConnection connection = CreateConnection();
Line 34: SqlCommand command = CreateCommand(connection, query, parameters);
Line 35: SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);
Line 36:
Line 37: Type datatype = factory.GetDataType();

Source File: c:\Inetpub\blogplankroad\App_Code\Utilities\SqlDatabase.cs Line: 35

Hi Planker,

Just as the exception message describes, the user account you're using to connect to the database does not have permission to perform a SELECT on the certain table.

In the SQL Server Management Studio, please open the user property window and grant the proper permission for the user.

HTH. If this does not answer you question, please feel free to mark it as Not Answered and post your reply. Thanks!

Deploying a database witch uses the membership tables

I have a website that uses an SQL 2005 Express database, with the added aspnet_users, aspnet_roles tables etc' inside it.
(That is not an .mdf file, but in the databse itself)

Are there any guidelines for moving this kind of database to the deployment server, which also has SQL Express ?

Is it just a case of detach + attach ?

Hi,

Detach + Attach will ship the whole database (tables, sp, users....)

Regards

deploy sql server express to ISP

To deploy sql server express to an ISP that supports Sql Server, I backed up the .mdf and .ldf files.

I can connect to the ISP database with Sql Server Mangement Studio Express. That connection requires a password.

When I try to execute 'restore', I get an error for no permission.

Any ideas why I have no permission after a password has already been entered?

I sure appreciate any help.

You will need to contact your ISP to discover what permissions you have on thier server. If you're getting a no permission error, it means that you don't have permission to perform a RESTORE on the server. SQL security is not all or nothing, you can be assigned a whole range of permissions that each imply certain rights.

Is RESTORE the way your ISP recomends putting databases on thier system? I'd actually be kind of surprised if it was, most ISP do not give this level of permissions to thier users.

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

|||

Finally --

I found a solution.

The problem was the ISP. They were not helpful at all. I quit and went to discountasp.net (yea) -- they have a tool to convert sql server express over to sql server 2005 and they have answered all of my questions within just an hour or so.

Thanks for your help Mike.

|||

Glad that it worked out for you CK. I'm also glad the discountasp.net has a tool to upload your database easily.

I'll make one minor nit just so it's mentioned in the thread. I think it's important for folks to understand that SQL Express is SQL Server 2005. There is not difference between the database files, all the same data types are supported, etc. SQL Express has fewer functions, but that's all. This is pretty normal, think about all the applications that offer a "lite" or "personal" edition with reduced functionaltiy, and then when you pay, you get additional functionality, same thing here.

You don't need to convert the SQL Express database, it's already exactly the same. The confusion stems from two issues:

Some Hosters allow you to move your database to the site using the Import/Export wizard, which isn't currently in SQL Express. This makes it hard to get your database on the server and we're working with Hosters to get the whole upload story working for SQL Express users.|||

Hi Mike, very pleased to find your post. I have a website built in VWD express, where deployment to an isp fails with this:

... (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) ...

After a rather frustrating 2 days I've arrived at the same conclusion as you suggest, that isp's do not really support sql express, and they annoyingly avoid saying so in their blurb. Yet the VWD Express deployment went just fine, so I just have to fix the SQL stuff.

From your post are you saying that SQL Express is Enterprise ManagerLite, but under the hood, its still system tables like sysobjects and so on, just inaccessible. Or is SQL Express reduced in actual scope and reach, regardless of accessibilty. I cannot find a SQL express query window on its own, it seems that the only interface is from within VWD which is sufficient, although much reduced from Enterprise Manager. This must be Lite.

Reason I ask is so that I can understand better what happens when i transfer my database (at least its contents) from my local machine to my isp. Following your logic, do my SQL Express .mdf (with or without .ldf) files attach/detach seamlessly between SQL Express and SQL 2005 and back. In which case I just have to find an isp who will allow attach/detach. Then I alter the connection string in web.config to use the server/database on the isp's machine as per MSDN. Then it should work?

Hope this brightens your day, then maybe you can shed some light ...

Charlie

|||

Charlie,

I'm sorry about your 2 days of frustration. I know exactly what you are going through. The ISP that caused me 3 weeks of frustration (1) told me on the phone before I signed up that VWD/SQL Server Express would work fine (2) sent me solutions from multiple techs that required Enterprise Manager - which is NOT available from SQL Express and (3) would not admit they didn't know.

Of course I bought into the idea that VWD is for hobbyists and lite-weights, forcing me to pass my frustrations on to this forum(!), but now that is behind me and I am a happy camper.

Here's an article that helped me: http://aspnet.4guysfromrolla.com/articles/040506-1.aspx

deploy SQL Server Express

Problem: (asp.net 2.0)

I x-copy from my development server a database named C:\site_test\site.mdf to C:\site. When I attach the database with Server Management Studio Express, it list the name as: "C:\site_test\site.mdf" eventhough on the live server the database is in the C:\site directory and my connection string in my web.config is "C:\site\site.mdf".

But everything works until a week later when I need to make a field change to a table on the live site: I'm forced to re-attach the database, but this time it list the database as:C:\site\site.mdf". When I re-attach I get a NT AUTHORITY\SERVICE does not have permission. So I give NT AUTHORITY\SERVICE permission on the directory and files and ownership with Server Management Stuidio Express, but I still get the error.

What am I'm doing wrong? Thanks for the help

--Dietrich

Hi Dietrich,

If you have attached the .mdf file to database manually, please check if you have set the connection string accordingly.

It has to be "Data Source=ServerName\Instancename; Initial Catelog=DatabaseName"

Deploy C# Express app with SQL Server express DB

Hello Everyone,

I have developed an application in Visual C# Express Edition, that uses a SQL Server Express database. I am deploying it using ClickOnce, and I'm wondering if there are any settings I have to change to SQL Server express, in order for my application to be able to access the database, since I'm getting an error when I start the application. I consider myself a beginner developer, so please take that in mind, I'm looking for the easiest way to do this.

Any help will be highly appreciated,

Andrs

Is SQL Server Express installed as a prerequisite within the ClickOnce deployment or will a SQL Server be accessed which is not on the current client ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de

Deploy apps using sql 2005 express

i'm building apps using sql server express and I want to deploy to servers that have the 2.0 .net framework but have sql server 2000 database.

Can this be done, and if so, how?

Observing God’s Holy Spirit, I see God saying that The Lord Jesus influences every natural occurrence of kindness, righteousness, and judgment _{(Jeremiah 9:23-24)}. I believe God, so I thank The Lord Jesus for your grace in these matters.

The database format used by SQL 2005 is not compatible with that used in SQL 2000, so you can't deploy the database by copying and attaching the mdf file to the deployed server.

You could deploy your application by using scripts to create your database on the target server. The Embedding SQL Express white paper discusses one way to do this.

|||

WHy do you want to develop in a much higher version of SQL Server for deploying it to an older version of SQL Server ? I am a developer on my own, and I never would do that due to compability issues. YOu can either use the developer edition for developing of SQL 2000 or the msde which would give you in most cases the same results that you will have like on the deployed system.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

I'm experimenting with the new Microsoft express technologies, but my production hosting company has not yet upgraded to sql server 2005, but is still using sql server 2000. I found information that leads me to understand that the visual web developer express edition does not support any database except sql server 2005 express. So, I tried this new MS tech that did not work on the old servers.

Nevertheless, by the faith of The Lord Jesus, I thank The Lord Jesus for His kindness to me by the information you provided . And, by God's grace thru Christ Jesus, I'm a improved person after trying something different. Perhaps, you will find similar satisfaction in God's mercy through Christ Jesus if you did things that you thought you would never do.

Best Wishes