Assistance with MSSQL Database - set up new server.

$30-250 USD

Completed

Posted

almost 10 years ago

$30-250 USD

Paid on delivery

I have recently purchased a VPS. This VPS is Win Server 2012 and I have SQL Server Express running on it (my database requirements are basic). I have Restored a database from an old SQL Server but the user passwords have not been restored so when I try to login as one of the database users via a connection string I can't. I have one user (sa) but as far as I can tell this user doesn't have permission to set passwords or create users. I will be restoring several other databases once I get this one functioning so I need to know how to resolve this for future use. Desired Outcomes : To have my old users function as they once did (ie be able to set a password for them and use this as a login in a connection string) in this database. To know how to do the above in any future restored databases. To know how to set passwords for these users, and users in future restored databases, in SSMS. To know how to get the setup so I can create new users in SSMS for any new databases

Microsoft SQL Server

VPS

Project ID: 6074224

About the project

7 proposals

Remote project

Active 10 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@amarcel20

sounds pretty simple you restored a database from another server here is a hint logins are tied to servers where as users are tied to the databases we will just need to sync the logins with the current server should take no more than an hour

$56 USD in 1 day

5.0

(1 review)

1.5

7 freelancers are bidding on average $100 USD for this job

@Lee2133

Hi thanks for invyting me to bid hope u weĺ let mr know when ur available thanks......................................

$250 USD in 3 days

4.9

(22 reviews)

5.2

@LearningNew

A proposal has not yet been provided

$34 USD in 3 days

5.0

(4 reviews)

4.8

@tanujchugh

A proposal has not yet been provided

$111 USD in 1 day

4.5

(18 reviews)

4.3

@shallufreelancer

A proposal has not yet been provided

$34 USD in 3 days

4.4

(1 review)

3.7

@mk73rc

We will help you restoring database with username help in resolving username issue.. I am available on skype for further discussion, please share your skype ID Regards, Manoj Kumar About Cubic Leading Messaging, collaboration and managed service provider. Since 2002, we are managing and maintaining the IT infrastructure for multiple clients spread across from UK , Middle East, US, Australia, Africa, & India. We support 2100+ and network devices. We have our own hosted infrastructure where we provide 1000+ VPS, 2,50,000+ mailboxes and 125 SharePoint servers are serving our customers Here is a partial list of technologies we work. Microsoft / Wintel Vertical + Managed Services & Administration of AWS / Azure / MS Windows Servers/ Exchange/ Lync/ SQL/ SharePoint/ Office 365/ CRM/ Dynamics + SharePoint / Office 365 programming, customization & application development + Migration of mail servers to Exchange / Google Apps & Office 365 etc. + Exchange Servers 2013/10/07, SharePoint 2013/10/07, SQL 2012/ 2008/ 2005 Migration and Implementation. + Windows Server 2012/08/03 Hyper V, Active Directory implementation / upgrade / migration + Veeam / Vmware deployments Thanks for taking time in going through the proposal and please revert in case you need any clarifications.

$147 USD in 2 days