Adding rules,roles and administrators to my website

Hi ,

I am trying to add users,rules,roles and administrators to my website, of course on my local server everything was ok, but now I can't login with my users on the server.

Basicly I created users and rules on my comp, and copied the App_data DB file to the root\app_data that is on the server(Using godaddy).

I understand that if the data is on the server it is no longer uses the DB in the root\app_data , but only the asp tables which are on MSSQL database.

I need help in copying the data from the data base in the App_data folder to the hosting database. I couldn't find the answers in the godaddy website help nor how to use their stored procedures to insert all the above.

(if I need to use the stored procedures please explain how)

Thanks very much for your help

Hi yrcaesar,

From the description, I understand you want to copy the datas from an absolute database (mdf, ldf) to a SQL Server on the server. If I have misunderstood your concern, please feel free to let me know.

I think you can simply attach the database for this scenario. Copy the database files to the server. Attach the database by right click "Databases" node in SQL Server Management Studio and select "Attach…" in the content menu.

Adding new subscription to SQL Server 2005s Local Subscriptions fails...

Hi everyone,

I am trying to add a new subscription to the local subscriptions of a SQL Server 2005. As soon as I click on SERVER_NAME -> Replication -> Local Replications -> New Subscription, I get the following error message:

TITLE: New Subscription Wizard
Microsoft SQL Server Management Studio is unable to access replication components because replication is not installed on this instance of SQL Server. For information about installing replication, see the topic Installing Replication in SQL Server Books Online.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=Microsoft.SqlServer.Management.UI.ReplUtilitiesErrorSR&EvtID=ReplicationNotInstalled&LinkId=20476
ADDITIONAL INFORMATION:

Die EXECUTE-Berechtigung wurde für das 'sp_MS_replication_installed'-Objekt, 'mssqlsystemresource'-Datenbank, 'sys'-Schema verweigert. (Microsoft SQL Server, Error: 229)
Translated from German to english:
EXECUTE-Permission for the 'sp_MS_replication_installed'-Object, 'mssqlsystemresource'-Database, 'sys'-Schema denied. (Microsoft SQL Server, Error: 229)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=229&LinkId=20476
BUTTONS:

OK

Btw, I am using the SQL Server Management Studio.
Thanks,
Olcay

From the error message, it appears that the replication components are not installed on the machine. Can you install the components and try again?|||

Hi Mahesh,

they are installed. Could this be a rights related issue?

Thanks,
Olcay

|||

Yes, it is then a permissions related issue.

What user is trying to create the subscription? This user should be the dbo of the subscrber database and atleast PAL (publication access list) user on the publication and publisher database.

Adding new subscription to SQL Server 2005s Local Subscriptions fails...

Hi everyone,

I am trying to add a new subscription to the local subscriptions of a SQL Server 2005. As soon as I click on SERVER_NAME -> Replication -> Local Replications -> New Subscription, I get the following error message:

TITLE: New Subscription Wizard
Microsoft SQL Server Management Studio is unable to access replication components because replication is not installed on this instance of SQL Server. For information about installing replication, see the topic Installing Replication in SQL Server Books Online.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=Microsoft.SqlServer.Management.UI.ReplUtilitiesErrorSR&EvtID=ReplicationNotInstalled&LinkId=20476
ADDITIONAL INFORMATION:

Die EXECUTE-Berechtigung wurde für das 'sp_MS_replication_installed'-Objekt, 'mssqlsystemresource'-Datenbank, 'sys'-Schema verweigert. (Microsoft SQL Server, Error: 229)
Translated from German to english:
EXECUTE-Permission for the 'sp_MS_replication_installed'-Object, 'mssqlsystemresource'-Database, 'sys'-Schema denied. (Microsoft SQL Server, Error: 229)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=229&LinkId=20476
BUTTONS:

OK

Btw, I am using the SQL Server Management Studio.
Thanks,
Olcay

From the error message, it appears that the replication components are not installed on the machine. Can you install the components and try again?|||

Hi Mahesh,

they are installed. Could this be a rights related issue?

Thanks,
Olcay

|||

Yes, it is then a permissions related issue.

What user is trying to create the subscription? This user should be the dbo of the subscrber database and atleast PAL (publication access list) user on the publication and publisher database.

adding new objects to sql server

We have an instance of sql running on one box. We're going to be making a copy of a database on another server. I've been working on a local copy of the db and I've had to add a few new stored procedures and tables along with some fts catalogs. When we set up the copy on the production server, I figured I'd set up the new version that I've been working on so it has the latest structures in place. However, we then have to pull all the data over from the existing database to the new one. Obviously the new tables won't get any data input from the pull, but aside from creating a dtsx project to pull it all over, is there any other way to do it a little easier and faster? Thanks.you can create a backup of your test db and restore it to the production server.|||how about snapshot replication

Adding Domain Local Group as SQL Logins

Hi,
I can not found Domain Local Group when I was adding SQL Logins. But, I foun
d them when using NTFS permission on the same computer. My Domain is 2000 Na
tive mode, SP3 was installed on the SQL Server and everyone group was added
in Pre-windows 2000 Acces
s Group. What's the problem? Help plz.
Rgds,
Harry"HarryNg" <anonymous@.discussions.microsoft.com> wrote in message
news:A6900F4B-1424-4444-9403-4E64FE94669D@.microsoft.com...
> I can not found Domain Local Group when I was adding SQL Logins. But, I
found them when using NTFS permission on the same computer. My Domain is
2000 Native mode, SP3 was installed on the SQL Server and everyone group was
added in Pre-windows 2000 Access Group. What's the problem? Help plz.
Hi, Please see my other post to your question in this newsgroup.
Steve

Adding Domain Local Group as Logins

Hi,
I can not found Domain Local Group when I was adding SQL Logins. But, I foun
d them when using NTFS permission on the same computer. My Domain is 2000 Na
tive mode, SP3 was installed on the SQL Server and everyone group was added
in Pre-windows 2000 Acces
s Group. What's the problem? Help plz.
Rgds,
Harry"HarryNg" <anonymous@.discussions.microsoft.com> wrote in message
news:180922DE-A85E-4D3D-8AB4-ECF10EED154B@.microsoft.com...

> I can not found Domain Local Group when I was adding SQL Logins. But, I
found them when using NTFS permission on the same computer. My Domain is
2000 Native mode, SP3 was installed on the SQL Server and everyone group was
added in Pre-windows 2000 Access Group. What's the problem? Help plz. <
This may be by design. A very simple workaround, create a local group on
your server running SQL Server, then add your domain global group into the
local group on your server. Then, add the (server) local group to the SQL
Server login and give it the proper db permissions...
Steve|||This was a bug that was fixed.
825042 FIX: SQL Server Jobs That Are Owned by Non-sysadmin Users May Not
Start
http://support.microsoft.com/?id=825042
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

adding data entered in to web textbox to rdlc report

I have a report services report that I created in local mode that takes data from a dataset and creates a report off of it. I need to add a field into the report that shows some of the data that the user enters in to the textboxes on the web page. Can someone explain to me how to do this or point me to a resource that will show me. Thanks!!

Pass the textbox data as parameters to your report. This entails simply loading the textbox(es) data into a parameter array & passing it to your report. Cheers!

Adding a User account

I have a user that is a local user on a machine. Is it possible that it coul
d
access SQL server on another machine, if they are both under the same domain
.
E.g.
User1 is on Box1
SQL Server is on Box2
Box1 and Box2 are both part of the Boxes domain.
Can I give User1 permission to access to a database on the Box2 SQL Server
without actually making User1 part of the Boxes domain as a user on its doma
inDoes this local user in Box1 has a valid domain user login in the Boxes
domain?
Anith|||No. User1 is only a user in Box1
"Anith Sen" wrote:

> Does this local user in Box1 has a valid domain user login in the Boxes
> domain?
> --
> Anith
>
>|||If it is not a valid domain user, then you have to use SQL Server
authentication.
AMB
"DBA" wrote:
> I have a user that is a local user on a machine. Is it possible that it co
uld
> access SQL server on another machine, if they are both under the same doma
in.
> E.g.
> User1 is on Box1
> SQL Server is on Box2
> Box1 and Box2 are both part of the Boxes domain.
> Can I give User1 permission to access to a database on the Box2 SQL Server
> without actually making User1 part of the Boxes domain as a user on its domain[/co
lor]|||In that case, you cannot use windows authentication in SQL Server, use SQL
Server authentication with a valid SQL login and password instead.
Anith