Help Desk and PC Inventory Software by Gritware   Gritware Support Forums
Gritware Support Forums
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
robwaybro

Member
Registered:
Posts: 6
Reply with quote  #1 
After migrating, I now realized our computers no longer display.  

While I look at the database to make sure they indeed did migrate, is there possibly a setting or permission that has changed or needs to be set.  For the WebTracksUser, following the instructing in the Upsizing to SQL Server guide, I set the membership role to db_datareader, db_datawriter, db_owner.  I have restarted the server.

Thank you..
robwaybro

Member
Registered:
Posts: 6
Reply with quote  #2 
I just verified that the dbo.Computer table did not migrate.  When I run SELECT* FROM dbo.Computer; it returns no data.

To make sure it was in the database before, I opened the exact Access database file I migrated from and the Computer table is populated with 214 records.

Thanks in advance for any assistance.

robwaybro

Member
Registered:
Posts: 6
Reply with quote  #3 
I was able to export the table from the Access database to an Excel file and then import it into MSSQL.

Thanks.

Previous Topic | Next Topic
Print
Reply

Quick Navigation:

Easily create a Forum Website with Website Toolbox.